Re: Multiple Foreign Keys to same table and field

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Robert Fitzpatrick <robert(at)webtent(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple Foreign Keys to same table and field
Date: 2002-12-26 03:09:12
Message-ID: 20021225190642.W87119-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 23 Dec 2002, Robert Fitzpatrick wrote:

> Is it possible to have multiple Foreign Keys in one table on different
> fields related to the same field in one other table?

It should be in some cases. What version are you using? If it's not 7.3
then you'll definately have problems I think since I believe one set of
the fixes may have gone in between 7.2 and 7.3, but if you're using 7.3
then I may have missed a case.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zurron 2002-12-26 11:27:38 Hardware requirement
Previous Message Jefim Matskin 2002-12-25 07:55:58 Re: FW: BUG in trigger and foreign keys