Re: boolean field default value

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: boolean field default value
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4AC9CEE@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на boolean field default value  ("Michael Schmidt" <MichaelMSchmidt@msn.com>)
Список pgadmin-support
In fact, pgAdmin does appear to set the default correctly, however, boolean fields in the data grid default to false regardless of what value is set as the default in the schema. If you insert data using raw SQL, or some other interface it should do what you expect. I think this is one of those 'feature-not-bugs'. I'll add it to my list of things to look at to see if we can improve it.
 
Regards, Dave.


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Michael Schmidt
Sent: 28 August 2005 23:43
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] 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.
 

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Michael Schmidt"
Дата:
Сообщение: boolean field default value
Следующее
От: "Dave Page"
Дата:
Сообщение: FW: problem pasting text into a column in 'view data' window