Postgres Pro
Downloads
Home   >   mailing lists

Foreign Keys to Non-primary keys? - Mailing list pgsql-general

From zilch@home.se
Subject Foreign Keys to Non-primary keys?
Date
Msg-id 20010621135927.A22434@loony
Whole thread Raw
Responses Re: Foreign Keys to Non-primary keys?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Tree view 
Is it possible to have a foreign key to a non-primary key (also meaning non-unique and therefore non-indexed) column i
atable? 

I can only imagine the performance loss...


---
Daniel Åkerud, zilch@home.se

pgsql-general by date:

Previous
From: Einar Karttunen
Date:
Subject: Re: Call for alpha testing: planner statistics revisions
Next
From: Martin Weinberg
Date:
Subject: WAL and problems with loading a large table