BUG #11520: Cannot uncheck to set false - Mailing list pgsql-bugs

From thangalin@gmail.com
Subject BUG #11520: Cannot uncheck to set false
Date
Msg-id 20140929212106.7639.89207@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #11520: Cannot uncheck to set false
List pgsql-bugs
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...

pgsql-bugs by date:

Previous
From: sudalait2@gmail.com
Date:
Subject: BUG #11518: full_page_writes is off after executing pg_start_backup()
Next
From: David Gould
Date:
Subject: Re: BUG #11264: Auto vacuum wraparound job blocking everything