[GENERAL] boolean default value

2005-08-28 Thread Michael Schmidt
I've not been able to find anything on this in the groups or by Google. I have a table with several boolean columns, all not null and with either 'true' or 'false' as default values. I've been testing the system in pgAdmin III. When I insert a new record, all the boolean columns are set

Re: [GENERAL] boolean default value

2005-08-28 Thread Michael Fuhr
On Sun, Aug 28, 2005 at 03:31:17PM -0600, Michael Schmidt wrote: I've not been able to find anything on this in the groups or by Google. I have a table with several boolean columns, all not null and with either 'true' or 'false' as default values. I've been testing the system in pgAdmin III.

Re: [GENERAL] boolean default value

2005-08-28 Thread Michael Schmidt
Mr. Fuhr, Thanks for your quick response. In fact, the problem doesn't occur in psql or in EMS PostgreSQL Manager. It appears unique to pgAdmin III. In the future, I'll check such things with psql before asking a (potentially dumb) question. Again, thanks! Michael Schmidt