Multiple primary keys

From: Mike Cianflone <mcianflone(at)littlefeet-inc(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Multiple primary keys
Date: 2001-05-01 21:39:10
Message-ID: B9F49C7F90DF6C4B82991BFA8E9D547B17D0FF@BUFORD.littlefeet-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Does Postgres support multiple primary keys in any way? It doesn't
seem to directly support it in that if I try to specify two primary keys it
fails on the second one.
What I'm trying to do is constrain the input based upon two columns,
rather than just one column. For example, the user can input (0,0), and then
(0,1), and then (0,2), and that would be fine. Then later the user could
input (1,0), and then (1,1) and then (1,2), and that would be fine also.
Since my constraint (or set of primary keys) would be based upon the two
columns, not just the first, it's ok to duplicate the first value as long as
both the first and second value are unique as a pair.

Does anyone know how to make a pair constraint?

Thanks for any pointers.

Mike Cianflone

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Mike Cianflone 2001-05-01 22:14:31 RE: Multiple primary keys
Previous Message Tom Lane 2001-04-30 23:08:44 Re: PostgreSQL Feature Sheet