Re: Are UseDeclareFetch and UseServerSidePrepare mutually exclusive?

Hi Jack,

(2013/05/11 3:27), ljwilson wrote:
> I've seen conflicting information on this:
> http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp2189601p2189614.html
> <http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp2189601p2189614.html>
>
> What I see with the latest source tree in my test environment of two windows
> workstations, each using the latest compiled odbc drivers (09.01.02??) to
> connect to PostgreSQL 9.2.4 (Windows):
>
> 1. With UserDeclareFetch=1 and UseServerSidePrepare=0, works as it always
> has for me.
> 2. With UserDeclareFetch=0 and UseServerSidePrepare=1, works as it always
> has for me.
> 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.

It seems very strange to me.
Do the workstations issue DDL commands or vacuum commands?

regards,
Hiroshi Inoue