Re: how to create an index on serial column

Steve Morrow (smorrow@dotrisc.cfr.usf.edu) wrote: : Hi Jaswant, : A unique index is automatically built on a serial column. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ This is not true. A serial column doesn't guarantee uniqueness. An index is not auto- matically built. The only way to guarantee uniqueness is to build a unique index on that column. I can't answer why alter table is giving him trouble, though.