boolean field default value

From: "Michael Schmidt" <MichaelMSchmidt(at)msn(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: boolean field default value
Date: 2005-08-28 22:42:43
Message-ID: BAY101-DAV16F13C76B70E586331D9DBA3AC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

It seems there is a problem with pgAdmin III 1.2.2 using PostgreSQL 8.0.3 in Windows XP. I have a boolean field set as not null with default value of true. When I insert a record, the field value is set to false as the default. This does not happen in psql or with EMS PostgreSQL Manager, where the field is correctly set to true. So, this appears to be unique to pgAdmin and not a problem with PostgreSQL.

Thanks,
Michael Schmidt

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-08-28 23:23:10 Re: boolean field default value
Previous Message Andreas Pflug 2005-08-26 10:03:06 Re: connect/install problems