Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple Foreign Keys to same table and field - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple Foreign Keys to same table and field
Date
Msg-id 12335.1040684231@sss.pgh.pa.us
Whole thread Raw
In response to Multiple Foreign Keys to same table and field  ("Robert Fitzpatrick" <robert@webtent.com>)
Responses Re: Multiple Foreign Keys to same table and field  ("Robert Fitzpatrick" <robert@webtent.com>)
List pgsql-general
Tree view 
"Robert Fitzpatrick" <robert@webtent.com> writes:
> Is it possible to have multiple Foreign Keys in one table on different
> fields related to the same field in one other table?

Offhand I think that should work.  Could we see a complete example of
what's going wrong for you?

            regards, tom lane

pgsql-general by date:

Previous
From: "Robert Fitzpatrick"
Date:
Subject: Multiple Foreign Keys to same table and field
Next
From: Tom Lane
Date:
Subject: Re: server closed the connectio unexpectedly