Re: Vote on SET in aborted transaction

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
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:53:55
Message-ID: 200204250253.g3P2rtG11747@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-04-25 02:54:36 Re: Vote on SET in aborted transaction
Previous Message Hiroshi Inoue 2002-04-25 02:52:44 Re: Vote on SET in aborted transaction