Re: [pgadmin-hackers] [pgadmin-support] pgAdmin4 and boolean columns

Hi Surindar – nice to talk!

 

Yep – I’m running 1.5 at present – the issue RM2218 sounds similar but isn’t actually the same – my issue was related to the number of times you have to select the Boolean cell to make it change. For instance if you select it three times rather than four it reverts to null.

 

I just assume the intended action is that it starts as a default (maybe null); a single mouse click changes it to false, and a further mouse click change it to true, and then repeated mouse clicks toggle round the  three options – if of course null is a possible default for that cell.

 

If the cell is NOT NULL by definition, the default should be false and it will just toggle between true and false.

 

Cheers

 

Nigel

 

 

 

Dr Nigel Tucker

System Architect

Specialised Structures NZ

Telephone Direct (NZ) +64 (0) 3 482 2473

 

                       

 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Surinder Kumar
Sent: Wednesday, 31 May 2017 6:13 PM
To: Nigel Tucker
Cc: pgAdmin Support
Subject: Re: [pgadmin-support] pgAdmin4 and boolean columns

 

Hi Nigel,

 

​Already a similar issue RM2218 logged which is resolved.

 

Also, which version of pgAdmin4 you are using ?

 

On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker <nigel@specialisedstructures.co.nz> wrote:

Hi,

 

pgAdmin4 has difficulty with setting or changing Boolean check boxes in Windows 10.

 

Double clicking on a Boolean cell initially null converts the display to an empty box, which on leaving that cell displays ‘false’.

If you return to the box and click once on it, it switches to a ticked box – which on leaving the cell shows ‘null’.

If however you double click on the cell, it converts to a ticked box which on leaving the cell shows true.

 

So – the mechanism for converting a Boolean cell from true to false requires five button presses, and from false to true requires four button presses. This has to be excessive and makes direct editing any number of rows a real pain.

 

Cheers

 

Nigel

 

Dr Nigel Tucker

System Architect

Specialised Structures NZ

Telephone Direct (NZ) +64 (0) 3 482 2473