[GENERAL] unable to avoid a deadlock at the end of a long transaction

I've been having this: psql:include/custom/import_update.custom.sql:63: ERROR: deadlock detected DETAIL: Process 13349 waits for AccessExclusiveLock on relation 250510 of database 248569; blocked by process 14153. Process 14153 waits for ShareLock on transaction 59160779; blocked by process

Re: [GENERAL] unable to avoid a deadlock at the end of a long transaction

Ivan Sergio Borgonovo m...@webthatworks.it writes: I've been having this: psql:include/custom/import_update.custom.sql:63: ERROR: deadlock detected DETAIL: Process 13349 waits for AccessExclusiveLock on relation 250510 of database 248569; blocked by process 14153. Process 14153 waits for

Re: [GENERAL] unable to avoid a deadlock at the end of a long transaction

On Fri, 07 May 2010 10:29:20 -0400 Tom Lane t...@sss.pgh.pa.us wrote: Ivan Sergio Borgonovo m...@webthatworks.it writes: I've been having this: psql:include/custom/import_update.custom.sql:63: ERROR: deadlock detected DETAIL: Process 13349 waits for AccessExclusiveLock on relation