Re: A transaction in transaction? Possible? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: A transaction in transaction? Possible?
Date
Msg-id 20041109135501.GA4099@winnie.fuhr.org
Whole thread Raw
In response to A transaction in transaction? Possible?  ("Andrei Bintintan" <klodoma@ar-sd.net>)
List pgsql-sql
On Tue, Nov 09, 2004 at 10:47:06AM +0200, Andrei Bintintan wrote:

> Is it possible to have another transatction in a transaction???

PostgreSQL 8.0 (currently in beta) has savepoints, so you'll be
able to do this:

BEGIN;
UPDATE orders SET technikernotiz='51' WHERE id=16143;
SAVEPOINT foo;
UPDATE orders SET reklamationsdetail='51' WHERE id=16143;
ROLLBACK TO foo;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: "marc ratun"
Date:
Subject: INSERT INTO VIEW - Replacement
Next
From: Giulio Orsero
Date:
Subject: Drop all indexes of a table w/o knowing the index names