ALTER TABLE ADD CONSTRAINT

Поиск
Список
Период
Сортировка
От Ian Harding
Тема ALTER TABLE ADD CONSTRAINT
Дата
Msg-id saf6c00b.022@emgateways.co.pierce.wa.us
обсуждение исходный текст
Ответы Re: ALTER TABLE ADD CONSTRAINT  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I am generating scripts from MSSQL Server and converting them to create objects in PostgreSQL.  It is suprisingly easy.
However, I think I may have hit a rock. 

It appears that PostgreSQL does not support listing constraints to be added as in the following syntax:

alter table foo add
    constraint fk_foo_bar foreign key
    (
        fooid
    ) references bar (
        barid
    ),
    constraint fk_foo_baz foreign key
    (
        footooid
    ) references baz (
        bazid
    );

Is this true?  Is this something that is being considered for addition?

Also, I see that alter table add constraint does not work for defaults.  Is this something that is going to be added?

Thanks!!

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org


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

Предыдущее
От: Fran Fabrizio
Дата:
Сообщение: Trigger only firing once
Следующее
От: "Torsten Krämer"
Дата:
Сообщение: Archiver(tar): unable to find header for 52.dat