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