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
