Re: A bad behavior under autocommit off mode

Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> > 
> > 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, 
> 
> I don't think so. Anyway my proposal doesn't break backward
> compatibility at least.

If you would like to post your approach, we can take a vote and see
what people want.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073