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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Sean DavisDate: 2009-05-27 15:05:13
Subject: Re: Query Optimization
Previous:From: Luiz Eduardo Cantanhede NeriDate: 2009-05-27 14:50:29
Subject: Re: Query Optimization

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