Re: Which record causes referential integrity violation on delete

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Which record causes referential integrity violation on delete
Date: 2005-07-03 20:36:26
Message-ID: da9k01$nmg$3@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2005-07-03 21:04:31 Re: Which record causes referential integrity violation on delete
Previous Message Andrus Moor 2005-07-03 20:19:38 Re: Hot to restrict access to subset of data