From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | ljwilson <ljwilson(at)digitalav(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive? |
Date: | 2013-05-13 16:26:21 |
Message-ID: | 5191142D.10703@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
(2013/05/13 23:13), ljwilson wrote:
> 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
OK you wrote
> 3. With UserDeclareFetch=1 and UseServerSidePrepare=1, the first
> workstation that opens the database "wins". Then the second
> workstation cannot open the database on its own connection until
> the first workstation exits its program.
ISTM the second workstation is waiting for the return of a query when
the database is blocked to be opened.
Could you check it?
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Jan-Peter Seifert | 2013-05-13 16:29:06 | Re: psqlODBC 09.01.0100 Unicode version still crashes on long server messages? |
Previous Message | Carlos Muñoz Juste | 2013-05-13 15:49:57 | Re: Issue with Oracle Database Gateway for ODBC and Unicode |