Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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            Sweden

In response to

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group