Re: Fixes for autocommit = off - Mailing list pgsql-patches

From Joe Conway
Subject Re: Fixes for autocommit = off
Date
Msg-id 3DAD02BB.1060309@joeconway.com
Whole thread Raw
In response to Fixes for autocommit = off  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Fixes for autocommit = off  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Bruce Momjian wrote:
> Here are some patches I applied that attempt to fix some of our
> utilities for the 'autocommit = off' world.  I still need to do more
> work.

Speaking of autocommit = off, I was contemplating sending in a patch for
dblink with this in it:

   appendStringInfo(str,
                    "BEGIN;SET autocommit='on';COMMIT; %s",
                     GET_STR(PG_GETARG_TEXT_P(1)));

(where arg 1 is the user provided sql statement) to cover the non-persistent
connection case for dblink_exec. Is this the recommended client fix?

Joe


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Fixes for autocommit = off
Next
From: Denis Perchine
Date:
Subject: JDBC patch reduces memory consumption