| From: | Ries van Twisk <pg(at)rvt(dot)dds(dot)nl> |
|---|---|
| To: | Félix Sánchez Rodríguez <fesanch(at)ciego(dot)cult(dot)cu> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Deleting "parent" record |
| Date: | 2009-04-24 21:12:00 |
| Message-ID: | 30357167-FCB5-467A-9534-049B0B505B76@rvt.dds.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Apr 24, 2009, at 10:00 AM, Félix Sánchez Rodríguez wrote:
> 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.
You need to tell is the exact reason why it failed, and possible post
your table structure here without that we cannot do much.
Ries
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans Peter Ertz | 2009-04-24 21:31:13 | Problem with function-arguments |
| Previous Message | Kevin Grittner | 2009-04-24 20:00:24 | Re: Updating a very large table |