Re: Bug? {? = CALL insert_page_segment (?, ?)} - Mailing list pgsql-odbc

From Nils Gösche
Subject Re: Bug? {? = CALL insert_page_segment (?, ?)}
Date
Msg-id 000f01cfff17$4f45aa10$edd0fe30$@de
Whole thread Raw
In response to Re: Bug? {? = CALL insert_page_segment (?, ?)}  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Bug? {? = CALL insert_page_segment (?, ?)}
List pgsql-odbc
Michael wrote:

> On Wed, Nov 12, 2014 at 11:06 PM, Nils Gösche <cartan@cartan.de> wrote:

> > So, should I use the new driver together with this driver option on
> > our customers' servers? I had always left this option at its default
> > value (1), which seems to be the recommended setting. Or is this
> > something that will be fixed in the driver, and I should stick to 9.2.1
> > for the time being?

> UseServerSidePrepare default value has been switched from 0 to 1 in
> 09.03.0100, that's btw the value recommended for Postgres 7.4 onwards
> for quite some time.

Oh! I knew that it had been the recommended value, I just assumed it also must have been the default value, then :-) So
infact, our software has been running with UseServerSidePrepare=0 all the time. I can make a note for our support
peopleto tell every customer who runs into this problem to add this setting to his connection string. 

What I do not quite understand, however, is why it is even necessary for us to deviate from the recommended setting. Is
thereanything wrong with the way I am doing the query? Shouldn't it work with UseServerSidePrepare=1 as well? 

Regards,
--
Nils Gösche
"Don't ask for whom the <CTRL-G> tolls."



pgsql-odbc by date:

Previous
From: developer rohto
Date:
Subject: Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.
Next
From: "Prisma Computer - M. Neumann"
Date:
Subject: Re: application_name