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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group