Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Peter Eisentraut wrote:
> >> The standard only covers embedded C programs. Other interfaces that are
> >> covered by other standards require other settings.
>
> > My point was that _the_ standard requires autocommit off, not that
> > everyone is using autocommit off.
>
> Peter's point is good: the only interface that is actually subject to the
> part of the spec you are quoting is ecpg. It could reasonably be argued
> that libpq should only support autocommit-on, because that's the
> historical behavior that programs written atop libpq expect. The other
> client libraries have their own specs to adhere to.
But isn't that like saying that the spec doesn't apply to libpq at all.
Why would autocommit not apply but other queries specification apply?
-- 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