Re: AW: [HACKERS] Begin statement again - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: AW: [HACKERS] Begin statement again
Date
Msg-id m0yDToB-000BFRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to AW: [HACKERS] Begin statement again  (Zeugswetter Andreas <andreas.zeugswetter@telecom.at>)
List pgsql-hackers
Andreas wrote:
>
> I think we should depreciate the BEGIN/END keywords in SQL to allow them
> to be used for the new PL/SQL. So definitely leave them out of ecpg now.
> Only accept BEGIN WORK and BEGIN TRANSACTION. (do a sequence of commit work; begin work)
> BTW.: why is a transaction always open ? A lot of programs would never need a
> transaction. Is it because of cursors ?

    BEGIN/END  in  PL/SQL and PL/pgSQL doesn't mean transactions!
    It's just to group statements to a block. You  cannot  commit
    something inside a PostgreSQL function. All changes made by a
    function are covered by the  statements  transaction  or  the
    upper transaction block.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Begin statement again
Next
From: Michael Meskes
Date:
Subject: Re: [HACKERS] Begin statement again