Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive? - Mailing list pgsql-odbc

From ljwilson
Subject Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?
Date
Msg-id 1368454402233-5755243.post@n5.nabble.com
Whole thread Raw
In response to Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
No, just standard select/update statements. I set log_statement = 'ddl' in
postgresql.conf and did a reload just to make sure no ddl commands were
being executed.

Here is a list of the unique sql statements (first few words only) for a
test session (extracted with log_statement = 'all'):

BEGIN;declare "SQL_CUR05628E20" cursor for SELECT
COMMIT
INSERT INTO
RELEASE _EXEC_SVP_056292B0
SAVEPOINT _EXEC_SVP_056292B0
SELECT
UPDATE
close "SQL_CUR05628E20";commit
declare "SQL_CUR05628E20" cursor with hold for SELECT COUNT(*) FROM
delete from


Thanks...jack



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Are-UseDeclareFetch-and-UseServerSidePrepare-mutually-exclusive-tp5755080p5755243.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


pgsql-odbc by date:

Previous
From: "Jan-Peter Seifert"
Date:
Subject: Problem with special characters in password when using SQLDriverConnect
Next
From: "Carlos Muñoz Juste"
Date:
Subject: Re: Issue with Oracle Database Gateway for ODBC and Unicode