From: Marc G. Fournier <scrappy@postgresql.org>
To: pgsql-sql@postgresql.org
Subject: PL/SQL Function: self-contained transaction?
Date: Mon, 22 Aug 2005 14:16:30 -0300 (ADT)
Message-ID: <20050822141357.B1002@ganymede.hub.org> (raw)
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, can you do a begin/end within the function itself to 'force'
commit on a specific part of the function?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
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: scrappy@postgresql.org
Subject: Re: PL/SQL Function: self-contained transaction?
In-Reply-To: <20050822141357.B1002@ganymede.hub.org>
* 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