> -----Original Message-----
> From: Rod Taylor [mailto:rbt@zort.ca]
> Sent: 05 April 2002 20:26
> To: Dave Page
> Cc: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support
>
>
> I've been working away at pg_depend support so I can add
> RESTRICT and CASCADE bits to all the objects and actually
> have it work.
Aha, you'll be Jean-Michel's best friend for a good long while when you
submit that patch I'm sure. I've knocked a number of his ideas that I wasn't
convinced we could handle the dependencies reliably enough to implement
well. Our discussions just kept coming back to 'we need to wait for a
pg_depend'.
> You know.. Drop serials with drop of the table. Restrict
> table dropping if it's referenced via foreign key, won't let
> you drop the int4 type because it's used in a ton of places...
>
> Mind you, CASCADE on drop of type OID could be interesting...
It's almost tempting to try it!
Regards, Dave.