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