Joe Conway <mail(at)joeconway(dot)com> writes:
> Speaking of autocommit = off, I was contemplating sending in a patch for
> dblink with this in it:
> "BEGIN;SET autocommit='on';COMMIT; %s",
> (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?
You do not need the begin/commit here.
A bigger question is why dblink should be doing that at all... seems
like it should be the programmer's responsibility.
regards, tom lane
In response to
pgsql-patches by date
|Next:||From: Barry Lind||Date: 2002-10-16 16:36:53|
|Subject: Re: JDBC patch reduces memory consumption|
|Previous:||From: Denis Perchine||Date: 2002-10-16 13:03:04|
|Subject: JDBC patch reduces memory consumption|