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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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