[GENERAL] Re: ALTER TABLE ADD CONSTRAINT

2001-05-11 Thread Gregory Wood
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: I don't know why it won't

Re: [GENERAL] Re: ALTER TABLE ADD CONSTRAINT

2001-05-11 Thread Jeff Daugherty
Also, I see that alter table add constraint does not work for defaults. Is this something that is going to be added? That I do hope will be added since the only way to replicate the functionality is to drop, readd and repopulate a table. Greg I am not sure specifically what you are