Re: [GENERAL] Not your father's question about deadlocks

2006-11-17 Thread Tom Lane
Clarence Gardner <[EMAIL PROTECTED]> writes: > I'm still creeping up on the problem. I configured postgres to resolve > a deadlock only after a month, and now I seem to have a complete > snapshot of one of them. If you don't mind rebuilding Postgres from source, here's the patch as applied to 8.1

Re: [GENERAL] Not your father's question about deadlocks

2006-11-16 Thread Tom Lane
Clarence Gardner <[EMAIL PROTECTED]> writes: > That scenario seems quite simple, but I can't reproduce the deadlock with > this seemingly-identical sequence. This is a bug in 8.1 and up. The reason you couldn't reproduce it is that it requires a minimum of three transactions involved, two of whic