Skip site navigation (1) Skip section navigation (2)

Re: RFD: PostgreSQL Schema Support

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: 'Rod Taylor' <rbt(at)zort(dot)ca>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: RFD: PostgreSQL Schema Support
Date: 2002-04-05 19:40:10
Message-ID: FED2B709E3270E4B903EB0175A49BCB129335A@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Rod Taylor [mailto:rbt(at)zort(dot)ca] 
> Sent: 05 April 2002 20:26
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)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.

pgadmin-hackers by date

Next:From: frank_lupo@email.itDate: 2002-04-06 08:31:26
Subject: kill connection
Previous:From: Dave PageDate: 2002-04-05 19:35:32
Subject: Re: RFD: PostgreSQL Schema Support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group