On Mon, 08 Nov 2010 15:45:12 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Ivan Sergio Borgonovo <mail(at)webthatworks(dot)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.
What about not so recent 8.3.9?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it