Deleting "parent" record - Mailing list pgsql-admin

From Félix Sánchez Rodríguez
Subject Deleting "parent" record
Date
Msg-id 003801c9c4ed$732e09a0$3000a8c0@atenea
Whole thread Raw
Responses Re: Deleting "parent" record  (Ries van Twisk <pg@rvt.dds.nl>)
List pgsql-admin
Hi:
 
I can't delete a "parent" record from a table. The relation has "ON UPDATE CASCADE ON DELETE CASCADE". As far as know, that causes that when you delete a record from the parent table, the related one from the child table will be deleted as well. However, I had to first delete the child record and then delete the parent one. Is this normal on using PostgreSQL?? I first tried the removal by using PHP. When it failed, I thought it was a problem of my PHP code and I checked it manually from Navicat, it failed too.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Updating a very large table
Next
From: Ries van Twisk
Date:
Subject: Re: Deleting "parent" record