Re: [GENERAL] Nested transactions

[Bill Todd]

Scott Marlowe wrote:
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <p...@dbginc.com> wrote:
  
Does PostgreSQL support nested transactions as shown below?
BEGIN;
 ...do some stuff...
 BEGIN;
  ...more stuff...
 COMMIT;
COMMIT;
    

Postgresql uses savepoints.


  
Savepoints do not provide the same functionality as nested or parallel 
transactions because you cannot commit a savepoint. If  I need a second 
transaction I can always open a second connection so it is easy to get 
the behavior I need. Thanks.

Bill