postgres cascade weird behaviour - Mailing list pgsql-general

From Irwan Hendra
Subject postgres cascade weird behaviour
Date
Msg-id 1b75c9a80904161850p3a16a062ifd96cb73ffe9ab06@mail.gmail.com
Whole thread Raw
Responses Re: postgres cascade weird behaviour
List pgsql-general
Hi

I have table A with pk that is being referenced by 5 other tables as foreign key
I have put all those tables reference to be ON DELETE CASCADE
However for some reason when I tried to delete one of the row in table A, out of 5 tables, 1 of them didn't actually get deleted
but the transaction is completed successfully
so I ended up with a table that has a foreign key referenced to a row that doesn't exist anymore in table A

postgres is not reporting any error message, so I have no idea how to supply more information to this problem

any idea?

Thanks



pgsql-general by date:

Previous
From: Rick Schumeyer
Date:
Subject: Full text search strategy for names
Next
From: rolandpeng
Date:
Subject: Does anyone use postgreSQL(windows version)+Hibernate with middlegen?