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