Kevin Brown <[EMAIL PROTECTED]> writes:
> When the "deadlock" occurs:
> [EMAIL PROTECTED]:~> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
