Re: logging of transaction related events

Kent Tong wrote:
> 
> Hi,
> 
> Is it possible to log events related to transactions, in particular, about
> blocking? For example:
> 
>    INFO: transaction 123 is blocked waiting for locked held by transaction
> 456.

8.3 will have a log_lock_waits parameter which will do something like
that.

-- 
  Bruce Momjian          http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +