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

On Sat, 15 May 1999 leif@danmos.dk wrote:

> create table globalafvigelse 
>   (
>     id serial ,
>     startdato date,
>     slutdato date,
>     dagskema varchar(50),
>     primary key (globalafvigelse) 
>   );

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) );

Geoff