The following bug has been logged on the website:
Bug reference: 11520
Logged by: T X
Email address: thangalin@gmail.com
PostgreSQL version: 9.4beta2
Operating system: Linux
Description:
1. Create a table with a boolean column.
2. Add several rows of data, ensure at least one is set to "TRUE".
3. View the table data using the "view data" icon.
4. Double-click the TRUE value.
5. Uncheck the checkbox.
6. Click elsewhere (e.g., to another window).
Expected Results
The field should be set to false.
Actual Results
The field is set to blank.
Work Around
1. Uncheck the checkbox.
2. Carefully click the border of the checkbox.
3. Click the blue bracket-looking thing [] to the right of the checkbox.
4. Press ENTER when the word "FALSE" appears.
How it should work is follows:
1. User unchecks a TRUE checkbox.
2. UI sets the value to FALSE.
-and-
1. User presses DEL on a TRUE checkbox.
2. UI sets the value to NULL.
How it currently works is quite awkward for NOT NULL boolean fields...