Transactions

From: Luiz Eduardo Cantanhede Neri <lecneri(at)gmail(dot)com>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Transactions
Date: 2009-05-27 15:01:45
Message-ID: 252e1f290905270801x65226eb3s3c3293e5bd622da7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

What happens if I open 2 or more transactions?

BEING;
--SOME COMMANDS
BEGIN;
--SOME OTHERS COMMANDS
ROLLBACK;
BEGIN;
--EVEN MORE COMMANDS
COMMIT;
--ALMOST DONE WITH COMMANDS
COMMIT;

one internal commit / rollback affects the most outside transaction?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2009-05-27 15:05:13 Re: Query Optimization
Previous Message Luiz Eduardo Cantanhede Neri 2009-05-27 14:50:29 Re: Query Optimization