Yeah, this problem annoyed me last week. It seems the checkbox value doesn't cycle consistently; it should always go false -> true -> null -> ..., but I think what it was doing was current value -> false -> true -> null or similar, so it could take 3 clicks to get to null.
(the ordering above may be wrong, but you get the point I hope). Please fix :-) On Wed, May 31, 2017 at 10:25 AM, Surinder Kumar < surinder.ku...@enterprisedb.com> wrote: > Adding pgadmin-hackers > > On Wed, May 31, 2017 at 2:43 PM, Nigel Tucker < > ni...@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 <+64%203-482%202473> >> >> >> >> [image: SS with Custom] >> >> >> >> *From:* pgadmin-support-ow...@postgresql.org [mailto: >> pgadmin-support-ow...@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 >> <https://redmine.postgresql.org/issues/2218> logged which is resolved. >> >> >> >> Also, which version of pgAdmin4 you are using ? >> >> >> >> On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker < >> ni...@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 <+64%203-482%202473> >> >> >> >> [image: SS with Custom] >> >> >> >> >> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company