Search Postgresql Archives

Re: Really strange foreign key constraint problem blocking delete

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux