Re: altering a table to set serial function - Mailing list pgsql-general

> test=> alter table test add id int4 unique;
> NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index
> "test_id_key" for table "test"
> ALTER TABLE

    I'd add UNIQUE NOT NULL or PRIMARY KEY just in case some UPDATE tries to
modify the id field to NULL which would be a Very Bad Thing to do.