Deleting "parent" record

Поиск

Список

Период

Сортировка

От	Félix Sánchez Rodríguez
Тема	Deleting "parent" record
Дата	24 апреля 2009 г. 17:59:05
Msg-id	003801c9c4ed$732e09a0$3000a8c0@atenea обсуждение исходный текст
Ответы	Re: Deleting "parent" record
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Deleting "parent" record