Horton

Re: Vote on SET in aborted transaction

Hiroshi Inoue <inoue@tpf.co.jp>

View thread View on postgr.es
From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Michael Loftis <mloftis@wgops.com>, Jan Wieck <janwieck@yahoo.com>, Tom Lane <tgl@sss.pgh.pa.us>, Thomas Lockhart <lockhart@fourpalms.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-04-25T02:52:44Z
Lists: pgsql-hackers 
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;

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