Horton

Re: Vote totals for SET in aborted transaction

Lee Kindness <lkindness@csl.co.uk>

View thread View on postgr.es
From: Lee Kindness <lkindness@csl.co.uk>
To: "Marc G. Fournier" <scrappy@hub.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Vince Vielhaber <vev@michvhf.com>, Mike Mascari <mascarm@mascari.com>, Lee Kindness <lkindness@csl.co.uk>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-04-26T08:46:04Z
Lists: pgsql-hackers 
Marc G. Fournier writes:
 > Myself, I wonder why Oracle went the route they went ... does anyone have
 > access to a Sybase / Informix system, to confirm how they do it?  Is
 > Oracle the 'odd man out', or are we going to be that?  *Adding* something
 > (ie. DROP TABLE rollbacks) that nobody appears to have is one thing ...
 > but changing the behaviour is a totally different ..

FWIW, Ingres also doesn't rollback SET. However all its SET
functionality is the sort of stuff you wouldn't assume to rollback:

 auto-commit
 connection
 journaling
 logging
 session
 work locations
 maxidle

You cannot do something sane like modify the date output through SET.

Lee.