On Mon, 08 Nov 2010 15:45:12 -0500 Tom Lane <[email protected]> wrote:
> Ivan Sergio Borgonovo <[email protected]> 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. What about not so recent 8.3.9? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
