Received: from spider.pilosoft.com (p55-222.acedsl.com [160.79.55.222]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66Daaa61566 for ; Fri, 6 Jul 2001 09:36:36 -0400 (EDT) (envelope-from alex@pilosoft.com) Received: from localhost (alexmail@localhost) by spider.pilosoft.com (8.9.3/8.9.3) with ESMTP id JAA02130; Fri, 6 Jul 2001 09:47:17 -0400 (EDT) Date: Fri, 6 Jul 2001 09:47:17 -0400 (EDT) From: Alex Pilosov To: =?iso-8859-1?Q?Daniel_=C5kerud?= cc: PostgreSQL-general Subject: Re: Transactions within a function In-Reply-To: <000a01c10618$ca7f0bb0$c901a8c0@automatic100> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by postgresql.org id f66Daba61568 X-Archive-Number: 200107/165 X-Sequence-Number: 12080 On Fri, 6 Jul 2001, [iso-8859-1] Daniel Åkerud wrote: > Do the BEGIN and END in a function also indicate that it is done in a > transaction? Or can you put another BEGIN TRANSACTION; END > TRANSACTION; in there? No. Functions cannot start/stop transactions, as postgresql does not currently support nested transactions. BEGIN/END are pascalish/adaish things identical to { and } in C. -alex