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

[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