Re: [JDBC] problem with new autocommit config parameter
Joe Conway <mail@joeconway.com>
From: Joe Conway <mail@joeconway.com>
To: snpe <snpe@snpe.co.yu>
Cc: pgsql-hackers@postgresql.org, pgsl-jdbc@postgresql.org
Date: 2002-09-07T19:12:36Z
Lists: pgsql-hackers
snpe wrote:
>>Sure, you can do SHOW autocommit.
>
> I am interesting with JDBC driver.
> When I make connection in base I want that driver find autocommit mode
> (from postgresql.conf or call in backend) and set mode true or false
>
You could make a call to current_setting in the backend.
I don't know anything about the jdbc driver, but if it's written in C
something like this should work:
text *autocommit = DatumGetTextP(DirectFunctionCall1(current_setting,
CStringGetDatum("autocommit")));
Would this work?
Joe