Re: Problem with FKEYS - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Re: Problem with FKEYS
Date
Msg-id 3FB3B03D.9030809@trade-india.com
Whole thread Raw
In response to Re: Problem with FKEYS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

  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.


No, That is not the case , they are plain tables.




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

Could not replicate it with newly created tables. Only those set of
table
has the problem. I am ready to provide any required info .

Regds
Mallah.




            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

pgsql-general by date:

Previous
From: Paulo Jan
Date:
Subject: Re: Perfomance difference between 7.2 and 7.3
Next
From: "mboscia"
Date:
Subject: Re: change conndeferrable in pg_constraint?