On Sat, 15 May 1999 leif(at)danmos(dot)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