pg_depend - Mailing list pgsql-hackers

From Bruce Momjian
Subject pg_depend
Date
Msg-id 200107160500.f6G50GF08398@candle.pha.pa.us
Whole thread Raw
Responses Re: pg_depend
List pgsql-hackers
I have found that many TODO items would benefit from a pg_depend table
that tracks object dependencies.  TODO updated.

---------------------------------------------------------------------------

DEPENDENCY CHECKING / pg_depend

* Auto-destroy sequence on DROP of table with SERIAL, perhaps with a separate SERIAL type
* Prevent column dropping if column is used by foreign key
* Propagate column or table renaming to foreign key constraints
* Automatically drop constraints/functions when object is dropped
* Make constraints clearer in dump file
* Make foreign keys easier to identify 

--  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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Planned changes to pg_am catalog
Next
From: Oleg Bartunov
Date:
Subject: Re: Translators wanted