Re: Vote on SET in aborted transaction

Tom Lane wrote:
> 
 
> Right offhand, I am not seeing anything here for which there's a
> compelling case not to roll it back on error.
> 
> In fact, I have yet to hear *any* plausible example of a variable
> that we would really seriously want not to roll back on error.

Honetsly I don't understand what kind of example you
expect. How about the following ?

[The curren schema is schema1]

	begin;
	create schema foo;
	set search_path = foo;
	create table t1 (....);
	.
   [error occurs]
	rollback;
	insert into t1 select * from schema1.t1;

Should the search_path be put back in this case ?
As I mentioned already many times, it doesn't seem
*should be* kind of thing.

regards, 
Hiroshi Inoue
	http://w2422.nsk.ne.jp/~inoue/