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; > COMMIT
It's not really any different than other errors. The commit doesn't complain (although it also doesn't actually commit anything). sszabo=# begin; BEGIN sszabo=# select * from foo; ERROR: relation "foo" does not exist sszabo=# commit; COMMIT ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
