Re: Bug? {? = CALL insert_page_segment (?, ?)}

From: Nils Gösche <cartan(at)cartan(dot)de>
To: "'Michael Paquier'" <michael(dot)paquier(at)gmail(dot)com>
Cc: "'Inoue, Hiroshi'" <inoue(at)tpf(dot)co(dot)jp>, "'PostgreSQL mailing lists'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Bug? {? = CALL insert_page_segment (?, ?)}
Date: 2014-11-13 07:56:18
Message-ID: 000f01cfff17$4f45aa10$edd0fe30$@de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Michael wrote:

> On Wed, Nov 12, 2014 at 11:06 PM, Nils Gösche <cartan(at)cartan(dot)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 in fact, our software has been running with UseServerSidePrepare=0 all the time. I can make a note for our support people to 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 there anything 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."

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Prisma Computer - M. Neumann 2014-11-13 08:24:47 Re: application_name
Previous Message developer rohto 2014-11-13 07:09:50 Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.