BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character

From: "Kjh" <kjh(at)networks(dot)nera(dot)no>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character
Date: 2005-05-04 12:18:30
Message-ID: 20050504121830.42759F0B10@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1646
Logged by: Kjh
Email address: kjh(at)networks(dot)nera(dot)no
PostgreSQL version: 8.0
Operating system: windows XP
Description: ERROR: column "mycolumn" is of type boolean but
expression is of type character
Details:

newest drivers (JDBC3)
deployed it with JBoss 3.2.6

Indeed, the entity bean has fields of java-type Boolean and the database has
fields of type boolean, but the application server seems to send it to the
database as "true" or "false" strings. That is what the errormessage
indicates to me anyway: ERROR: column "mycolumn" is of type boolean but
expression is of type character. (Though I am not aware of how to verify
this other than changing column type varchar(5) which I have tried -
unfortunately, this had lots of other undesired side-effects even though it
worked in some cases.)

Entity beans with Boolean types works fine with mysql and mssql, though with
the BIT type in the database, instead of boolean. However, if I try to use
the BIT type, I bump into another error: My data base SEED TOOL fails to
load data with the following error ERROR: column "mycolumn" is of type bit
but expression is of type boolean

sigh(!)
please help.
Kjetil

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-05-04 14:22:52 Re: BUG #1645: Auto complete SQL "COPY" have problems.
Previous Message Boris van Schooten 2005-05-04 09:40:19 Re: BUG #1643: dbf2pg broken + quick fix