Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] MSAccess and primary keys

From: Ole Gjerde <gjerde(at)icebox(dot)org>
To: "Geoffrey C(dot) Speicher" <geoff(at)sirius(dot)trassociates(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] MSAccess and primary keys
Date: 1999-05-16 05:54:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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

In response to

pgsql-interfaces by date

Next:From: Alf LewerkenDate: 1999-05-16 08:19:14
Subject: Re: [INTERFACES] libpq++ and arrays?
Previous:From: Ole GjerdeDate: 1999-05-16 05:50:45
Subject: Re: [INTERFACES] Re: [sql] mysql vs. postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group