From: A. Kretschmer <akretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Re: PL/SQL Function: self-contained transaction?
Date: Mon, 22 Aug 2005 20:15:08 +0200
Message-ID: <20050822181508.GA14469@webserv.wug-glas.de> (raw)
In-Reply-To: <20050822141357.B1002@ganymede.hub.org>
References: <20050822141357.B1002@ganymede.hub.org>
am 22.08.2005, um 14:16:30 -0300 mailte Marc G. Fournier folgendes:
>
> In PostgreSQL, as everyone knows, a QUERY == a transaction, unless wrap'd
> in a BEGIN/END explicitly ... how does that work with a function? is there
> an implicit BEGIN/END around the whole transaction, or each QUERY within
> the function itself?
>
> If the whole function (and all QUERYs inside of it) are considered one
> transaction,
Yes, exactly.
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akretschmer@despammed.com
Subject: Re: PL/SQL Function: self-contained transaction?
In-Reply-To: <20050822181508.GA14469@webserv.wug-glas.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox