X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1124832A17E for ; Wed, 29 Sep 2004 07:21:05 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97863-07 for ; Wed, 29 Sep 2004 06:20:57 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 8993E32A174 for ; Wed, 29 Sep 2004 07:20:55 +0100 (BST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i8T5a8CC032398; Wed, 29 Sep 2004 08:36:08 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i8T5a72C032394; Wed, 29 Sep 2004 08:36:07 +0300 Date: Wed, 29 Sep 2004 08:36:07 +0300 (EEST) From: Achilleus Mantzios To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: FOREIGN KEY and AccessExclusiveLock In-Reply-To: <14192.1096380314@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/252 X-Sequence-Number: 19098 O Tom Lane έγραψε στις Sep 28, 2004 : > Achilleus Mantzios writes: > > Whats the purpose of the AccessExclusiveLock on parent table? > > We're adding a trigger to it.