Re: Which record causes referential integrity violation on delete - Mailing list pgsql-general

From Andrus Moor
Subject Re: Which record causes referential integrity violation on delete
Date
Msg-id da9k01$nmg$3@news.hub.org
Whole thread Raw
In response to Which record causes referential integrity violation on delete  ("Andrus" <noeetasoftspam@online.ee>)
List 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 by date:

Previous
From: David Pratt
Date:
Subject: Trigger help
Next
From: Jamie Deppeler
Date:
Subject: SET AUTOCOMMIT TO OFF is no longer supported