From: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Nils Gösche <cartan(at)cartan(dot)de>, 'Michael Paquier' <michael(dot)paquier(at)gmail(dot)com> |
Cc: | 'PostgreSQL mailing lists' <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Bug? {? = CALL insert_page_segment (?, ?)} |
Date: | 2014-11-13 11:46:09 |
Message-ID: | 54649A01.2080303@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 2014/11/13 16:56, Nils Gösche wrote:
> 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?
Yes it should work.
Currently there are some bugs about handling output parameters.
It would be fixed in the next release.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-11-13 13:48:36 | Re: application_name |
Previous Message | Prisma Computer - M. Neumann | 2014-11-13 08:24:47 | Re: application_name |