Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
> -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

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
> -Original Message- > From: Tim Finch, FosterFinch Ltd [mailto:[EMAIL PROTECTED]] > Sent: 05 April 2002 17:23 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support > > > At 13:40 05/04/2002 +0100, Dave Page wrote: > >I'm currently sta

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Rod Taylor
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

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
> -Original Message- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: 05 April 2002 19:06 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support > > > That would be me. > > Lots more work to be done on domains yet though (foreign > ke

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Rod Taylor
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 a

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread pgsql
At 13:40 05/04/2002 +0100, Dave Page wrote: >I'm currently starting to implement support for some of the more desirable >features of PostgreSQL 7.3 which is now well in development. One of these I wish the desirable features for 7.3 included all of alter table implemented. Do you know if it is B

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
BTW Rod, I forgot to mention, thanks for the Domain support in 7.3 (I assume you're the only Rod Taylor around here). A nice feature - I'm just finishing adding support to pgAdmin... Note to Frank Lupo: Domains implement what the patch to pgAdmin that you sent me did, only in PostgreSQL itself. N

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
> -Original Message- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: 05 April 2002 15:34 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support > > > Option 2 is certainly the best long term. A couple of > releases from now and very

Re: [pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Rod Taylor
Option 2 is certainly the best long term. A couple of releases from now and very few people will be using 7.2 or prior -- and they should expect newer tools to be broken . Support namespaces in the cleanest way possible, and potentially add a temporary hack (for the length of 7.3.x releases and

[pgadmin-hackers] RFD: PostgreSQL Schema Support

2002-04-05 Thread Dave Page
I'm currently starting to implement support for some of the more desirable features of PostgreSQL 7.3 which is now well in development. One of these areas (which are all now on the ToDo list incidently) is Schema support. There are a number of ways we could implement this, and I'd like to get some