Re: Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?

(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