Re: RFD: PostgreSQL Schema Support

> -----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.