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
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