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.
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...
--
Rod Taylor
----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "'Rod Taylor'" <rbt@zort.ca>; <pgadmin-hackers@postgresql.org>
Sent: Friday, April 05, 2002 2:18 PM
Subject: RE: [pgadmin-hackers] RFD: PostgreSQL Schema Support
>
>
> > -----Original Message-----
> > From: Rod Taylor [mailto:rbt@zort.ca]
> > Sent: 05 April 2002 19:06
> > To: Dave Page; pgadmin-hackers@postgresql.org
> > Subject: Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support
> >
> >
> > That would be me.
> >
> > Lots more work to be done on domains yet though (foreign
> > keys, check constraints, etc.), but those will have to come
> > in some other weekend.
> >
> > I think you'll really enjoy my next patch (should be
> > submitted soon). If it goes through it'll make your life
> > quite a bit easier -- then again, maybe not.
>
> That sound ominous, what is it?
>
> Dave.
>