Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66H3Ia69681 for ; Fri, 6 Jul 2001 13:03:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 2.12 #1) id 15IZ0v-000C7l-0W; Fri, 6 Jul 2001 18:03:34 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id CEF0814397; Fri, 6 Jul 2001 17:44:25 +0100 (BST) Message-ID: <003601c1063a$ea739e00$1001a8c0@archonet.com> From: "Richard Huxton" To: "Wei Weng" , References: <994437701.16301.0.camel@Monet> Subject: Re: Is function atomic? Date: Fri, 6 Jul 2001 17:44:22 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/70 X-Sequence-Number: 3854 From: "Wei Weng" > If it is not, is it possible to acquire a lock on a row ? how about a > lock on a table? All functions take place within a transaction, but since PG doesn't support nested transactions yet you can't roll back the effects of a nested function. - Richard Huxton