Horton

Re: synchronized snapshots

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jim Nasby <jim@nasby.net>, Joachim Wieland <joe@mcknight.de>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-08-17T01:54:44Z
Lists: pgsql-hackers 
On Tue, 2011-08-16 at 21:08 -0400, Robert Haas wrote: 
> attaching it to BEGIN feels natural to me.

My only objection is that people have different expectations about
whether the session will remain in a transaction block when they
encounter an error. So, it's hard to make this work without surprising
about half the users.

And there are some fairly significant consequences to users who guess
that they will remain in a transaction block in case of an error; or who
are just careless and don't consider that an error may occur.

> If we did add another toplevel command, what would we call it?

"SET TRANSACTION SNAPSHOT" perhaps?

Regards,
	Jeff Davis