Ivan Sergio Borgonovo <m...@webthatworks.it> writes:
> I get
> DETAIL: Process 24749 waits for ShareLock on transaction 113443492;
> blocked by process 25199. Process 25199 waits for ShareLock on
> transaction 113442820; blocked by process 24749.
> I would like to know both statements that caused the sharelock
> problem.
Recent versions of PG record both (or all) statements involved in a
deadlock in the postmaster log.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
