Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> >
> > Hiroshi Inoue wrote:
> > Hiroshi, we need a psql solution too. People are feeding query files
> > into psql all the time and we should have an appropriate behavior for
> > them.
>
> 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.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026