pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (5+ messages)  latest in thread

Message-ID: <200107061323.f66DNaJ21413@jupiter.us.greatbridge.com>
Permalink:  ../200107061323.f66DNaJ21413@jupiter.us.greatbridge.com/
Also on:    postgresql.org/message-id/200107061323.f66DNaJ21413@jupiter.us.greatbridge.com

 · 

reply

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