Re: two primairy key in one table ? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: two primairy key in one table ?
Date
Msg-id 20020705100233.X27855-100000@megazone23.bigpanda.com
Whole thread Raw
In response to two primairy key in one table ?  (Angela Luyf <a.c.luyf@amc.uva.nl>)
Responses Re: two primairy key in one table ?  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
On Thu, 4 Jul 2002, Angela Luyf wrote:

> Hello,
> I have a database model where a many to many relation is used, so i need
> to create a table with two primary key. Don't know how to solve this in
> postgress, can't find it in the tutorials, so can anybody help me with
> this ?

You can't have multiple primary keys in a table (per SQL spec) but are
you sure that's what you want as opposed to a single key made of two
columns?





pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: plpgsql: PERFORM SELECT id INTO TEMP TABLE ..
Next
From: Joe Conway
Date:
Subject: Re: explicit cast error