Bruce Momjian 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. > > Yes, I think that is how it would behave. If you don't roll back 'set > search_path', you are pointing to a non-existant schema.
OK I see your standpoint. If Tom agrees with Bruce I don't object any more. regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
