Re: Bug report - ODBC Driver - Error 42P18

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Consolity Inc <consolity(at)outlook(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Bug report - ODBC Driver - Error 42P18
Date: 2014-02-28 16:32:03
Message-ID: 5310BA03.5060204@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 02/28/2014 08:20 AM, Consolity Inc wrote:
> The PostgreSQL ANSI ODBC driver reports 42P18 - ERROR: could not
> determine data type of parameter $<n>; when preparing SQL with an
> expression of the form:
>
> <bound parameter> IS NULL.
>
> This is a breaking change to existing code that depends on being able to
> check the NULL-ness of a parameter.
>
> Behavior is new as of psqlODBC 09.03.0100

There is a bug fix to the above version:

http://psqlodbc.projects.pgfoundry.org/docs/release.html

Not sure if that covers the error or not.

>
> PostgreSQL version: 9.3.2
> OS: Windows
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2014-02-28 16:50:52 Re: Bug report - ODBC Driver - Error 42P18
Previous Message Jeremy Thornton 2014-02-28 16:31:02 UUID, UUID-OSSP extension, and ODBC issue