Received: from aaanet.ru (aaanet.ru [213.59.98.254]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f177uAx20625 for ; Wed, 7 Feb 2001 02:56:10 -0500 (EST) (envelope-from tolik@tolikus.hq.aaanet.ru) Received: from tolikus.hq.aaanet.ru ([213.59.98.104]) by aaanet.ru with esmtp (Exim 3.12 #1) id 14QPSQ-000Acs-00; Wed, 07 Feb 2001 10:56:06 +0300 Received: (from tolik@localhost) by tolikus.hq.aaanet.ru (8.9.3/8.9.3) id KAA38562; Wed, 7 Feb 2001 10:56:09 +0300 (MSK) (envelope-from tolik) To: Ken Corey Cc: Subject: Re: Transactions in PLPGSQL? References: <01020412065705.18716@kenlinux.bithub.org> Mime-Version: 1.0 (generated by tm-edit 1.5) Content-Type: text/plain; charset=US-ASCII From: tolik@aaanet.ru (Anatoly K. Lasareff) Date: 07 Feb 2001 10:56:09 +0300 In-Reply-To: Ken Corey's message of "Sun, 4 Feb 2001 12:06:57 +0000" Message-ID: <86pugvudt2.fsf@tolikus.hq.aaanet.ru> Lines: 18 X-Mailer: Gnus v5.6.45/XEmacs 21.1 - "Canyonlands" X-Archive-Number: 200102/111 X-Sequence-Number: 1289 >>>>> "KC" == Ken Corey writes: KC> Hi All! KC> Are the BEGIN/END; seen in a typical PL/PGSQL function a transaction wrapper, KC> or do I need to add another BEGIN/END block? No, BEGIN & END in plpgsql function are not transaction control statemens, but elements of plpgsql language. KC> Should I just put a 'rollback' in the function, or do I need to do something KC> special? You _cannot_ use any transaction control statemens (commit, rollback) into plpgsql function. So all the function must be in transaction block. -- Anatoly K. Lasareff Email: tolik@aaanet.ru http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071