Re: Which record causes referential integrity violation on delete

Поиск
Список
Период
Сортировка
От Andrus Moor
Тема Re: Which record causes referential integrity violation on delete
Дата
Msg-id da9k01$nmg$3@news.hub.org
обсуждение исходный текст
Ответ на Which record causes referential integrity violation on delete  ("Andrus" <noeetasoftspam@online.ee>)
Список pgsql-general
> On Friday 01 July 2005 19:49, you wrote:
>> In Postgres 8 I tried commad
>>
>> DELETE FROM customer WHERE id=123
>
> (snip)
>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 8: explain analyze is your friend
>
>
> Automatically answered?! :-)
>
> explain analyze DELETE FROM customer WHERE id=123

Martin,

I tried the command explain analyze command but it produces exactly the same
error message
about referential integrity violation as

DELETE FROM customer WHERE id=123

How this command can help me ?

Andrus.



В списке pgsql-general по дате отправления:

Предыдущее
От: David Pratt
Дата:
Сообщение: Trigger help
Следующее
От: Jamie Deppeler
Дата:
Сообщение: SET AUTOCOMMIT TO OFF is no longer supported