Tom Lane wrote:Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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. Could not replicate it with newly created tables. Only those set of tableIf that's not it, can you provide a self-contained example? 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 |
- [GENERAL] Problem with FKEYS Rajesh Kumar Mallah
- Rajesh Kumar Mallah