Re: Vote on SET in aborted transaction - Mailing list pgsql-hackers

Bruce Momjian wrote:
> 
> Hiroshi Inoue wrote:
> >
> > What are you expecting for psql e.g. the following
> > wrong(?) example ?
> >
> >       [The curren schema is schema1]
> >         begin;
> >         create schema foo;
> >         set search_path = foo;
> >         create table t1 (....); [error occurs]
> >         commit;
> >         insert into t1 select * from schema1.t1;
> 
> I am expecting the INSERT will use the search_path value that existed
> before the error transaction began.
> 

So you see foo.t1 which is a copy of schema1.t1
if all were successful and you may be able to see
the doubled schema1.t1 in case of errors.

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