Re: Nested transactions

[Bill Todd <pg@xxxxxxxxxx>]

Scott Marlowe wrote:

On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <pg@xxxxxxxxxx> 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