Postgres Pro
Downloads
Home   >   mailing lists

multiple primary keys and reference - Mailing list pgsql-sql

From Matt
Subject multiple primary keys and reference
Date
Msg-id 3D0110C1.5020908@weilpublishing.com
Whole thread Raw
Responses Re: multiple primary keys and reference
Re: multiple primary keys and reference
List pgsql-sql
Tree view 
I have a table, OrderDetail, with two primary keys OrderID and ProductID

I want another table, Claims, to reference the primary keys of 
OrderDetail so that the pair has to match between table not just one 
attrib. I can't figure out how to do this from the docs I have. can 
anyone help? thankyou in advance

matthew berardi
weil publishing

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: VIEWs and FOREIGN keys
Next
From: Tulio Oliveira
Date:
Subject: Re: Limiting database size