Foreign Keys to Non-primary keys?

From: zilch(at)home(dot)se
To: - <pgsql-general(at)postgresql(dot)org>
Subject: Foreign Keys to Non-primary keys?
Date: 2001-06-21 11:59:27
Message-ID: 20010621135927.A22434@loony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is it possible to have a foreign key to a non-primary key (also meaning non-unique and therefore non-indexed) column i a table?

I can only imagine the performance loss...

---
Daniel Åkerud, zilch(at)home(dot)se

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Weinberg 2001-06-21 12:13:31 WAL and problems with loading a large table
Previous Message Einar Karttunen 2001-06-21 11:38:56 Re: Call for alpha testing: planner statistics revisions