Thread: Bug in boolean columns on win2k

RE-POST: This is a repost. Our mailserver was out of order when sending
this report yesterday, and I can't find the post on the buglist yet.
Sorry for any inconvenience.

BUG:
I have a table with the following column, from "psql \d":
showemail    | boolean                     |

When I try to insert data data into this through jdbc, I get the
following error:
java.sql.SQLException: ERROR: column "showemail" is of type boolean but
expression is of type text
         at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1130)
         at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:933)
         at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:139)
         at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:346)
         at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:294)
         at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:249)

---------------------------------------------------------------------
My environment:
postgreSQL 8.0-beta2-dev3
Win2k sp4 professional
jdbc driver: pgdev.305.jdbc3
java version: 1.4

The error also occured in beta1.

The following statement executed from psql works as expected:

insert into mytable (showemail) values ('true');

--
Thanks
Mads Peter Henderson

On Wed, 15 Sep 2004, Mads Peter Henderson wrote:

> I have a table with the following column, from "psql \d":
> showemail    | boolean                     |
>
> When I try to insert data data into this through jdbc, I get the
> following error:
> java.sql.SQLException: ERROR: column "showemail" is of type boolean but
> expression is of type text


Are you using something like PreparedStatement.setString to compose this
query?  You should be using setBoolean instead I imagine.

Kris Jurka