Skip site navigation (1) Skip section navigation (2)

Re: Vote on SET in aborted transaction

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Michael Loftis <mloftis(at)wgops(dot)com>,Jan Wieck <janwieck(at)yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Thomas Lockhart <lockhart(at)fourpalms(dot)org>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Vote on SET in aborted transaction
Date: 2002-04-25 02:52:44
Message-ID: 3CC76F7C.26B88ABC@tpf.co.jp (view raw or flat)
Thread:
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/

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-04-25 02:53:55
Subject: Re: Vote on SET in aborted transaction
Previous:From: Hiroshi InoueDate: 2002-04-25 02:37:36
Subject: Re: Vote on SET in aborted transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group