Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?

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.