Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

boolean field default value



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


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group