Re: Really strange foreign key constraint problem blocking delete - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Really strange foreign key constraint problem blocking delete
Date
Msg-id 54315D03.2010901@aklaver.com
Whole thread Raw
In response to Re: Really strange foreign key constraint problem blocking delete  (Tim Mickelson <tim_mickelson@bigfoot.com>)
Responses Re: Really strange foreign key constraint problem blocking delete
List pgsql-general
On 10/05/2014 07:37 AM, Tim Mickelson wrote:
> Sorry about that, the precise version is:  "PostgreSQL 9.1.9 on
> x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat
> 4.4.7-3), 64-bit"

Well 9.1 is at .14 now, so on general principles it would be a good idea
to upgrade. That being said I do not see anything in the release notes
from .10 to .14 that applies. Though to be truthful I did not read every
line. Before upgrading you could try what Andy suggested which is to
REINDEX(tmpautenticazione). See here for the REINDEX caveats, and a way
to INDEX CONCURRENTLY:

http://www.postgresql.org/docs/9.1/interactive/sql-reindex.html

>
>
> On 05/10/2014 15:54, Adrian Klaver wrote:
>> On 10/05/2014 04:03 AM, Tim Mickelson wrote:
>>> I can guarantee that there is no entry in channel_mapping with idaut =
>>> 1622, it is first deleted. I've double checked, also because the error
>>> is indicating precisely this. The Postgresql Version is 9.1
>>
>> FYI, when supplying the version number please include the third number
>> as it represents the bug fix release. This would help narrow the
>> search for possible causes of your issue. Also please do not top post
>> it makes it difficult to follow the thread.
>>
>>>
>>>
>>
>>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Really strange foreign key constraint problem blocking delete
Next
From: Andy Colson
Date:
Subject: Re: Really strange foreign key constraint problem blocking delete