> -----Original Message-----
> From: Rod Taylor [mailto:[EMAIL PROTECTED]] 
> Sent: 05 April 2002 20:26
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> 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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to