Re: ERROR: invalid input syntax for type boolean: "-"(#7)

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Peter van Heck" <usenet(at)heckwork(dot)nl>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ERROR: invalid input syntax for type boolean: "-"(#7)
Date: 2004-10-01 19:55:54
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4306878@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Peter van Heck
> Sent: 29 September 2004 02:53
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] ERROR: invalid input syntax for type boolean: "-"(#7)
>
> I get this error with an ms-access front-end boolean type
> field where access produces "-1" and Postgresql's bool field
> does not accept this.
>
> Im using Postgres 7.4.5, Access 2002, mdac 2.8, psqlodbc-07_03_0200.
>
> Is there a proper work around?

There is a 'True is -1' option on the second options dialog.

Regards, Dave

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2004-10-01 19:58:52 Re: problems with the ODBC driver
Previous Message Amir Zicherman 2004-10-01 18:36:08 Re: \n converted to \r\n