Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Nested BEGIN...COMMIT transactions - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [SQL] Nested BEGIN...COMMIT transactions
Date
Msg-id Pine.LNX.4.21.0002280051270.2468-100000@localhost.localdomain
Whole thread Raw
In response to Nested BEGIN...COMMIT transactions  (mpg4@duluoz.net)
List pgsql-sql
Tree view 
mpg4@duluoz.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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Rule (which multiple actions) problem with history table.....
Next
From: Peter Eisentraut
Date:
Subject: Re: [SQL] INSERT w/o variable names for a SERIAL type?