Re: Vote on SET in aborted transaction

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> 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 ?

Sure it should be.  Otherwise it's pointing at a nonexistent schema.

			regards, tom lane