Thread: BUG #11520: Cannot uncheck to set false

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...

On Tue, Sep 30, 2014 at 6:21 AM, <thangalin@gmail.com> wrote:

> 1. Uncheck the checkbox.
>

Postgres does not come up with a UI itself. What are you using here?
PGadmin? You should directly perhaps discuss with the people managing this
UI code..
--
Michael