Re: Really strange foreign key constraint problem blocking delete

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Really strange foreign key constraint problem blocking delete
Дата
Msg-id 54315D03.2010901@aklaver.com
обсуждение исходный текст
Ответ на Re: Really strange foreign key constraint problem blocking delete  (Tim Mickelson <tim_mickelson@bigfoot.com>)
Ответы Re: Really strange foreign key constraint problem blocking delete  (Andy Colson <andy@squeakycode.net>)
Список 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Really strange foreign key constraint problem blocking delete
Следующее
От: Andy Colson
Дата:
Сообщение: Re: Really strange foreign key constraint problem blocking delete