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/