Re: foreign keys with inherited tables

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Matt Magoffin <mmagoffin(at)proxicom(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign keys with inherited tables
Date: 2001-04-16 21:08:32
Message-ID: Pine.BSF.4.21.0104161402460.72603-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mon, 16 Apr 2001, Matt Magoffin wrote:

> This results in this error on the last INSERT statement:
>
> ERROR: foo_id_constraint referential integrity violation - key
> referenced from foobar not found in foo
>
> which I assume is because the foo(id = 2) object is actually in the bar
> table? Is there another way to get this foreign check to work?
>

Not currently in that form using the foreign key constraints. Hopefully
for 7.2.

I believe a work around using a separate key table was post about a month
ago or so.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Calvin Dodge 2001-04-16 21:19:23 Re: Driver ODBC postdrv.exe fails on 7.1
Previous Message Christopher Masto 2001-04-16 20:20:44 Re: Re: erServer beta