Received: from forward.airstreamcomm.net (forward.airstreamcomm.net [64.33.128.12]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66Hlca92155 for ; Fri, 6 Jul 2001 13:47:38 -0400 (EDT) (envelope-from jghasler@svtel.net) Received: from hasler.dhh.gt.org (elk-ras1-cs-155.dial.airstreamcomm.net [64.33.137.157]) by forward.airstreamcomm.net (8.9.3/8.9.3) with ESMTP id MAA22561 for ; Fri, 6 Jul 2001 12:47:33 -0500 (CDT) Received: from [192.168.1.3] (helo=toncho.dhh.gt.org ident=mail) by hasler.dhh.gt.org with esmtp (Exim 3.12 #1 (Debian)) id 15IZhU-0007cl-00 for ; Fri, 06 Jul 2001 12:47:32 -0500 Received: from john by toncho.dhh.gt.org with local (Exim 3.12 #1 (Debian)) id 15IZb0-0000K4-00; Fri, 06 Jul 2001 12:40:50 -0500 To: pgsql-sql@postgresql.org Subject: Re: Is function atomic? References: <994437701.16301.0.camel@Monet> <003601c1063a$ea739e00$1001a8c0@archonet.com> From: John Hasler Date: 06 Jul 2001 12:40:50 -0500 In-Reply-To: "Richard Huxton"'s message of "Fri, 6 Jul 2001 17:44:22 +0100" Message-ID: <87pubearbx.fsf@toncho.dhh.gt.org> Lines: 11 User-Agent: Gnus/5.0803 (Gnus v5.8.3) Emacs/20.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200107/74 X-Sequence-Number: 3858 Richard Huxton writes: > 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. Do you have any idea when it will? -- John Hasler john@dhh.gt.org (John Hasler) Dancing Horse Hill Elmwood, WI