public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Page <[email protected]>
To: Surinder Kumar <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Cc: Nigel Tucker <[email protected]>
Subject: Re: [pgadmin-support] pgAdmin4 and boolean columns
Date: Wed, 31 May 2017 10:32:00 +0100
Message-ID: <CA+OCxozLf8+FuOCM+-vi9NN8OUCjkBBba27DcxkO+TF2ZDK+Cg@mail.gmail.com> (raw)
In-Reply-To: <CAM5-9D-ETfSUykB3jy2CDrH4eMBYdWorGDjVPxkR6wzWshGZXg@mail.gmail.com>
References: <[email protected]>
<CAM5-9D-=KULwZQLuS81vjE3CUs73FxCm7A=HaH4TR7Gs9N5pyw@mail.gmail.com>
<[email protected]>
<CAM5-9D-ETfSUykB3jy2CDrH4eMBYdWorGDjVPxkR6wzWshGZXg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgadmin-hackers>
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 <
[email protected]> wrote:
> Adding pgadmin-hackers
>
> On Wed, May 31, 2017 at 2:43 PM, Nigel Tucker <
> [email protected]> 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:* [email protected] [mailto:
>> [email protected]] *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 <
>> [email protected]> 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
Attachments:
[image/jpeg] image001.jpg (16.7K, 3-image001.jpg)
download | view image
[image/jpeg] image002.jpg (16.7K, 4-image002.jpg)
download | view image
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [pgadmin-support] pgAdmin4 and boolean columns
In-Reply-To: <CA+OCxozLf8+FuOCM+-vi9NN8OUCjkBBba27DcxkO+TF2ZDK+Cg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox