From: | "Ian Harding" <ianh(at)co(dot)pierce(dot)wa(dot)us> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ALTER TABLE ADD CONSTRAINT |
Date: | 2001-05-07 22:30:39 |
Message-ID: | saf6c00b.022@emgateways.co.pierce.wa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)tpchd(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-05-07 22:46:47 | Re: User can not create a new table |
Previous Message | Joseph Shraibman | 2001-05-07 22:25:04 | Re: 'current' timestamp bug |