On Fri, 30 Jan 2004, Gaetano Mendola wrote:
> Hi all,
> is it normal that postgres dont complain
> doing a commit after a deadlock ?
> kalman=# select * from test where a = 5 for update;
> ERROR: deadlock detected
> DETAIL: Process 4144 waits for ShareLock on transaction 40180; blocked
> by process 4141.
> Process 4141 waits for ShareLock on transaction 40181; blocked by
> process 4144.
> kalman=# commit;
It's not really any different than other errors. The commit doesn't
complain (although it also doesn't actually commit anything).
sszabo=# select * from foo;
ERROR: relation "foo" does not exist
In response to
pgsql-admin by date
|Next:||From: Andrew Rawnsley||Date: 2004-01-30 02:19:23|
|Subject: Re: Forcing connections closed|
|Previous:||From: Mark Harrison||Date: 2004-01-30 01:00:27|
|Subject: hung postmaster when client machine dies?|