Thread: pgadmin does not display null in boolean field

Hello,
I am using a PostgreSQL-8.1.4-Database on a Linux SLES9 Server.
A Table in the Db contains some boolean-Fields. Most are set to true,
some to false and some to null.
pgAdmin III V1.4.2 (Mar 6 2006) and pgAdmin III V1.5 Devel (Feb 19 2006)
running on Win-XP-SP2 display the false- and true-field correctly. The
null-fields are not shown as (null) - they are also displayed as false.
Viewing the same table with Aqua Data Studio 4.7 correctly displays
true, flase or (null).

Is it possible to change the behaviour of displaying boolean fields, so
that null-fields can easily detected ?

Thanks in advance Hubert Plaschke

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> plaschke@ggrz-hagen.nrw.de
> Sent: 29 May 2006 08:29
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pgadmin does not display null in
> boolean field
>
> Hello,
> I am using a PostgreSQL-8.1.4-Database on a Linux SLES9 Server.
> A Table in the Db contains some boolean-Fields. Most are set to true,
> some to false and some to null.
> pgAdmin III V1.4.2 (Mar 6 2006) and pgAdmin III V1.5 Devel
> (Feb 19 2006)
> running on Win-XP-SP2 display the false- and true-field correctly. The
> null-fields are not shown as (null) - they are also displayed
> as false.
> Viewing the same table with Aqua Data Studio 4.7 correctly displays
> true, flase or (null).
>
> Is it possible to change the behaviour of displaying boolean
> fields, so
> that null-fields can easily detected ?

Done - will appear in 1.6 (and any future 1.5 snapshots).

Thanks for the report.

Regards, Dave.