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