From zilch@home.se Fri Jul 6 12:40:53 2001 Received: from smtp1.home.se (smtp1.home.se [195.66.35.200]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66Ceqa35513 for ; Fri, 6 Jul 2001 08:40:53 -0400 (EDT) (envelope-from zilch@home.se) Received: from automatic100 [195.54.154.30] by smtp2.home.se with Novonyx SMTP Server $Revision: 2.74 $; Fri, 06 Jul 2001 14:37:29 +0200 (ECTD) Message-ID: <000a01c10618$ca7f0bb0$c901a8c0@automatic100> From: =?iso-8859-1?Q?Daniel_=C5kerud?= To: "PostgreSQL-general" Subject: Transactions within a function Date: Fri, 6 Jul 2001 14:40:08 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C10629.8DD55A00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2465.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2465.0000 X-Archive-Number: 200107/159 X-Sequence-Number: 12074 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C10629.8DD55A00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Do the BEGIN and END in a function also indicate that it is done in a trans= action? Or can you put another BEGIN TRANSACTION; END TRANSACTION; in there? --- Daniel =C5kerud [ Don't underestimate the power of stupid people in large groups] ------=_NextPart_000_0007_01C10629.8DD55A00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Do the BEGIN and END in a function also in= dicate=20 that it is done in a transaction?
Or can you put another BEGIN TRANSACTION; = END=20 TRANSACTION; in there?
 
---
Daniel =C5kerud
 
[ Don't underestimate the power of stupid = people in=20 large groups]
------=_NextPart_000_0007_01C10629.8DD55A00-- From JanWieck@Yahoo.com Fri Jul 6 13:16:54 2001 Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by postgresql.org (8.11.3/8.11.1) with SMTP id f66DGsa52289 for ; Fri, 6 Jul 2001 09:16:54 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Jul 2001 13:16:49 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f66DNaJ21413; Fri, 6 Jul 2001 09:23:36 -0400 From: Jan Wieck Message-Id: <200107061323.f66DNaJ21413@jupiter.us.greatbridge.com> Subject: Re: Transactions within a function In-Reply-To: <000a01c10618$ca7f0bb0$c901a8c0@automatic100> from =?ISO-8859-1?Q?Daniel_=C5kerud?= at "Jul 6, 2001 02:40:08 pm" To: =?ISO-8859-1?Q?Daniel_=C5kerud?= Date: Fri, 6 Jul 2001 09:23:36 -0400 (EDT) CC: PostgreSQL-general X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/161 X-Sequence-Number: 12076 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? The BEGIN and END keywords in PL/pgSQL have absolutely no transactional meaning. They group statements into blocks with the possibility of named blocks using the <