From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: A bad behavior under autocommit off mode |
Date: | 2003-03-20 03:26:14 |
Message-ID: | 200303200326.h2K3QEu03590@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hiroshi Inoue wrote:
> > > > This patch removes that "stuff all queries into a single transaction"
> > > > behavior and makes them function just like queries arriving separately.
> > > > This does BREAK BACKWARD COMPATIBILITY. However, if they want the old
> > > > behavior, they just need to wrap BEGIN/COMMIT around the query string.
> > >
> > > Does the change worth the trouble ?
> > > Please don't break BACKWARD COMPATIBILITY easily.
> >
> > It clearly fixes an existing bug,
>
> My proposal also fixes the bug though Tom objected to it.
Yes, there are other ways to fix this --- but this is the cleanest, and
I think cleans up some surprising functionality. We cleaned up some
suprises in 7.3 (pg_atoi), and if we don't do cleanups like this, we
accumulate a system that behaves eratically --- as you showed in the
original report of psql -c not working for autocommit off.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-20 03:30:06 | Re: Nested transactions: low level stuff |
Previous Message | Hiroshi Inoue | 2003-03-20 03:21:10 | Re: Nested transactions: low level stuff |