Re: autocommit in 7.4 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: autocommit in 7.4
Date
Msg-id 200307310450.h6V4omG12741@candle.pha.pa.us
Whole thread Raw
In response to Re: autocommit in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: autocommit in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
The issue I have is that every interface that relies on libpq is going
to have to code it itself.  Is that OK?

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Is there a reason autocommit is implemented in psql and not in libpq via
> > a C function call?
> 
> One reason is that PQexec accepts multiple-query strings (possibly with
> embedded BEGIN/END), so it's not immediately obvious what the semantics
> ought to be.  We could probably work out some reasonable definition if
> we wanted to put effort into it, but seeing that libpq clients aren't
> historically expecting any autocommit support, I didn't find it a high
> priority task for 7.4.
> 
> At this point it's definitely too late for 7.4, anyway.  Put it on the
> TODO list if you feel strongly about it.
> 
>             regards, tom lane
> 

--  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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: this is in plain text (row level locks)
Next
From: Bruce Momjian
Date:
Subject: Re: followup on previous