Re: Problem with FKEYS - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with FKEYS
Date
Msg-id 8857.1068651617@sss.pgh.pa.us
Whole thread Raw
In response to Problem with FKEYS  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: Problem with FKEYS  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-general
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> How come pgsql7.3.4  Was allowing me to delete the master record while
> referencing records were present in slave table?

The only explanation I can think of is that the referencing row shown as
being in user_services was actually in a child table --- foreign keys
don't work in inheritance hierarchies at the moment.

If that's not it, can you provide a self-contained example?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Perfomance difference between 7.2 and 7.3
Next
From: Bruno Wolff III
Date:
Subject: Re: Perfomance difference between 7.2 and 7.3