From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: ALTER TABLE...ADD CONSTRAINT? |
Date: | 2000-11-23 03:07:19 |
Message-ID: | NEBBIOAJBMEENKACLNPCAEIOCCAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Is anybody working on:
>
> alter table <table> add constraint <name> primary key(column,...);
>
> or
>
> alter table <table> add constraint <name> unique(column,...);
>
> or
>
> alter table drop constraint
I'd be more than happy to work on either of the above in the current
implementation, however - I'm not sure it'd be worth it, given that the
constraints system might be up for a reimplementation.
> I guess this is not really a small task as it relates to unifying
> constraint handling, but for the PK & unique constraints at least, we must
> already have code that does the work - all(?) that has to happen
> is to make
> sure the ALTER command calls it...is that right?
That is a thought - can someone point me to the C file that handles CREATE
TABLE so I can see how it's done? I can't for the life of me find that bit
of code!
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-11-23 03:12:38 | ALTER TABLE...ADD CONSTRAINT? |
Previous Message | Don Baccus | 2000-11-23 02:56:42 | OpenACS datamodel vs. current PG 7.1 sources |