Обсуждение: 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@postgres
ql.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.c
o.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
Вложения
Adding pgadmin-hackersOn Wed, May 31, 2017 at 2:43 PM, Nigel Tucker <nigel@specialisedstructures.co.nz> wrote: 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@postgres
ql.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.c
o.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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company