pg_depend take 2

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

Browse pgsql-patches by date

  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