Re: Transactions

Kevin Brown <blargity@gmail.com> writes:
> When the "deadlock" occurs:

> kevin@ajbit:~> ps -elF | grep postgres
> 1 S postgres 6020 17767 0 75  0 - 10585 -   15136  0 19:57 ?
> 00:00:29 postgres: dli dli 127.0.0.1(39869) idle in transaction
> 1 S postgres 6195 17767 0 76  0 - 10323 semtim 14940  0 20:22 ?
> 00:00:28 postgres: dli dli 127.0.0.1(37735) INSERT waiting

> You can see an insert is just waiting.  On what?

I'd bet it's waiting on the "idle in transaction" transaction, which is
waiting for a nonresponding client.  But the pg_locks view would tell
you more.

            regards, tom lane