X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 44DD9D1D237 for ; Fri, 30 Jan 2004 01:11:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 99769-01 for ; Thu, 29 Jan 2004 21:11:08 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 51520D1D1D8 for ; Thu, 29 Jan 2004 21:11:05 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CB3E83563F; Thu, 29 Jan 2004 17:11:07 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C9D673562F; Thu, 29 Jan 2004 17:11:07 -0800 (PST) Date: Thu, 29 Jan 2004 17:11:07 -0800 (PST) From: Stephan Szabo To: Gaetano Mendola Cc: "pgsql-admin@postgresql.org" Subject: Re: commit after dead lock In-Reply-To: <4019A484.5010509@bigfoot.com> Message-ID: <20040129170739.U35951@megazone.bigpanda.com> References: <4019A484.5010509@bigfoot.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/287 X-Sequence-Number: 12150 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