Postgres Pro
Downloads
Home   >   mailing lists

Re: question about which column(s) are the right foreign key - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: question about which column(s) are the right foreign key
Date
Msg-id 1088176363.3189.15.camel@teetnang
Whole thread Raw
In response to question about which column(s) are the right foreign key  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
As a follow up, I now have object versions with the combined primary key
(object id, date and time of object version creation). Now when I need
to refer to an object version in a foreign key, do I let the object id
column itself reference the objects table in addition to it being part
of the foreign key to the object versions table?

Thanks.

-- 
Markus Bertheau <twanger@bluetwanger.de>

pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: question about which column(s) are the right foreign key
Next
From: Josh Berkus
Date:
Subject: Re: Question about a CIDR based query