On Mon, 08 Nov 2010 15:45:12 -0500 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
