RE: ALTER TABLE...ADD CONSTRAINT?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема RE: ALTER TABLE...ADD CONSTRAINT?
Дата
Msg-id NEBBIOAJBMEENKACLNPCAEIOCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на ALTER TABLE...ADD CONSTRAINT?  (Philip Warner <pjw@rhyme.com.au>)
Ответы Re: RE: ALTER TABLE...ADD CONSTRAINT?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: ALTER TABLE...ADD CONSTRAINT?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RE: ALTER TABLE...ADD CONSTRAINT?