Re: [INTERFACES] MSAccess and primary keys - Mailing list pgsql-interfaces

On Sat, 15 May 1999, Geoffrey C. Speicher wrote:
> You're misusing the PRIMARY KEY constraint; you're supposed to give it a
> list of attributes which function as the primary key for the table.  I'm
> surprised that was accepted at all.  I think what you want is:
> create table globalafvigelse
>   (
>      id serial,
>      ...
>      primary key (serial)
>   );

primary key(id) you mean? :)

The serial datatype automatically makes the field a primary key, so that
would be unnecessary anyway.

Ole Gjerde