From: | Rod Taylor <rbt(at)zort(dot)ca> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | pg_depend take 2 |
Date: | 2002-04-21 02:03:56 |
Message-ID: | 1019354637.8075.13.camel@knight.zort.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Major changes since last revision:
initdb changes to account for table structure and new PIN elements for
genbki.sh. Enables really easy pinning of data in a table you know the
ID of.
Most objects enforced RESTRICT / CASCADE options.
Still needs code to track foreign keys between tables (right now it
catches the triggers -- but not the relation. See 'Foreign keys and
indexes' on hackers.
Serials sequences are dropped with the cascade.
'drop' regression test rewritten to test restrict / cascade of various
stuff. It may be missing a few things, but implicit cascades are
defined elsewhere (indexes, triggers, etc.)
Thoughts:
Do system objects depend on users? DROP USER ... CASCADE (drop all
tables, triggers, etc. that the user owns).
Will schemas auto-cascade to everything within them using the normal
DROP stuff or should all objects in a schema depend on the schema
implicitly? Allows RESTRICT / CASCADE of a schema fairly quickly.
(Tom?)
Attachment | Content-Type | Size |
---|---|---|
depend.patch | text/plain | 115.0 KB |
TODO.depend | text/plain | 2.1 KB |
drop.out | text/plain | 5.0 KB |
pg_depend.c | text/x-c | 17.7 KB |
pg_depend.h | text/x-c-header | 2.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2002-04-21 17:39:46 | Re: [HACKERS] WITH DELIMITERS in COPY |
Previous Message | Joe Conway | 2002-04-20 06:01:19 | doc patch for ALTER TRIGGER |