Skip site navigation (1) Skip section navigation (2)

Re: Bug in boolean columns on win2k

From: Kris Jurka <books(at)ejurka(dot)com>
To: Mads Peter Henderson <mads(dot)henderson(at)tietoenator(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in boolean columns on win2k
Date: 2004-09-16 04:48:49
Message-ID: Pine.BSO.4.56.0409152340220.13474@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugs

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

In response to

pgsql-bugs by date

Next:From: Harald Armin MassaDate: 2004-09-16 05:56:11
Subject: Re: Cannot install properly on WinXP...
Previous:From: Bender, CherylDate: 2004-09-15 20:53:53
Subject: Re: Windows 8.0 beta on Server 2003 Installer problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group