Re: [GENERAL] How is this possible? (more on deadlocks)

2004-08-27 Thread Vivek Khera
> "CM" == Carlos Moreno <[EMAIL PROTECTED]> writes: CM> Ok, now I'm really intrigued by what looks to me CM> (possibly from a naive point of view) like a bug, CM> or rather, a limitation on the implementation. [[ ... ]] CM> I don't know about the internals of how transactions CM> and locks an

Re: [GENERAL] How is this possible? (more on deadlocks)

2004-08-24 Thread Stephan Szabo
On Tue, 24 Aug 2004, Carlos Moreno wrote: > Ok, now I'm really intrigued by what looks to me > (possibly from a naive point of view) like a bug, > or rather, a limitation on the implementation. Yep. See recent (and historical) discussions on needing a weaker lock than FOR UPDATE for handling fo

[GENERAL] How is this possible? (more on deadlocks)

2004-08-24 Thread Carlos Moreno
Ok, now I'm really intrigued by what looks to me (possibly from a naive point of view) like a bug, or rather, a limitation on the implementation. I can't find a reasonable justification why the following would cause a deadlock: I run two instances of psql using the same DB on the same machine. On