Re: [SQL] Nested BEGIN...COMMIT transactions

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: mpg4(at)duluoz(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Nested BEGIN...COMMIT transactions
Date: 2000-02-27 23:54:59
Message-ID: Pine.LNX.4.21.0002280051270.2468-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

mpg4(at)duluoz(dot)net writes:

> What's the behavior of nested sets of BEGIN ... COMMIT blocks?

You can't nest them. (Second BEGIN will fail.)

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Kirkwood 2000-02-27 23:57:26 Re: [SQL] New Optimizer Behaviour In 7.0b1
Previous Message Tom Lane 2000-02-27 23:41:39 Re: [SQL] Rule (which multiple actions) problem with history table.....