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
|
- [pgadmin-support] boolean field default value Michael Schmidt