Re: Problem with FKEYS

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