Horton

Re: possible constraint bug?

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Thomas Swan <tswan@olemiss.edu>, pgsql-hackers@postgresql.org
Date: 2000-10-12T20:25:08Z
Lists: pgsql-hackers 
> 
> On Thu, 12 Oct 2000, Bruce Momjian wrote:
> 
> > Is this addressed in 7.1?
> 
> Not as far as I know.
> It would require one or more of:
>  ALTER FUNCTION
>  ALTER TABLE ... DROP CONSTRAINT
>  a reference system that automatically drops/
>   restricts based on objects referencing the 
>   thing you drop (and this wouldn't make sense
>   for constraints without alter ... drop 
>   constraint anyway).
> 
> 

Added to TODO:

* Add ALTER FUNCTION
* Add ALTER TABLE ... DROP CONSTRAINT
* Automatically drop constraints/functions when object is dropped

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026