From: Jan Wieck <JanWieck@Yahoo.com>
To: Daniel Åkerud <zilch@home.se>
Cc: PostgreSQL-general <pgsql-general@postgresql.org>
Subject: Re: Transactions within a function
Date: Fri, 6 Jul 2001 09:23:36 -0400 (EDT)
Message-ID: <200107061323.f66DNaJ21413@jupiter.us.greatbridge.com> (raw)
In-Reply-To: <000a01c10618$ca7f0bb0$c901a8c0@automatic100>
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 <<label>> syntax
and then beeing able to EXIT up multiple block levels at
once.
Since every SQL statement sent to the backend outside of an
explicit transaction block has it's own implicit transaction
and we don't have subtransactions yet, there is no
possibility for transaction control inside of functions.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
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: JanWieck@Yahoo.com, zilch@home.se, pgsql-general@postgresql.org
Subject: Re: Transactions within a function
In-Reply-To: <200107061323.f66DNaJ21413@jupiter.us.greatbridge.com>
* 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