public inbox for [email protected]
help / color / mirror / Atom feedpgAdmin4 and boolean columns
5+ messages / 3 participants
[nested] [flat]
* pgAdmin4 and boolean columns
@ 2017-05-30 21:30 Nigel Tucker <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: Nigel Tucker @ 2017-05-30 21:30 UTC (permalink / raw)
To: [email protected]
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
SS with Custom
Attachments:
[image/jpeg] image002.jpg (16.7K, 3-image002.jpg)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 and boolean columns
@ 2017-05-31 05:05 Surinder Kumar <[email protected]>
parent: Nigel Tucker <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Surinder Kumar @ 2017-05-31 05:05 UTC (permalink / raw)
To: Nigel Tucker <[email protected]>; +Cc: pgAdmin Support <[email protected]>
Hi Nigel,
Please log the issue here <https://redmine.postgresql.org/projects/pgadmin4;
so that it can be tracked.
https://redmine.postgresql.org/projects/pgadmin4
Thanks
Surinder
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
>
>
>
> [image: SS with Custom]
>
>
>
Attachments:
[image/jpeg] image002.jpg (16.7K, 3-image002.jpg)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 and boolean columns
@ 2017-05-31 06:13 Surinder Kumar <[email protected]>
parent: Nigel Tucker <[email protected]>
1 sibling, 1 reply; 5+ messages in thread
From: Surinder Kumar @ 2017-05-31 06:13 UTC (permalink / raw)
To: Nigel Tucker <[email protected]>; +Cc: pgAdmin Support <[email protected]>
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
>
>
>
> [image: SS with Custom]
>
>
>
Attachments:
[image/jpeg] image002.jpg (16.7K, 3-image002.jpg)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgadmin-support] pgAdmin4 and boolean columns
@ 2017-05-31 09:25 Surinder Kumar <[email protected]>
parent: Surinder Kumar <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Surinder Kumar @ 2017-05-31 09:25 UTC (permalink / raw)
To: pgadmin-hackers; +Cc: Nigel Tucker <[email protected]>
Adding pgadmin-hackers
On Wed, May 31, 2017 at 2:43 PM, Nigel Tucker <[email protected]
o.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
>
>
>
> [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
>
>
>
> [image: SS with Custom]
>
>
>
>
>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [pgadmin-support] pgAdmin4 and boolean columns
@ 2017-05-31 09:32 Dave Page <[email protected]>
parent: Surinder Kumar <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Dave Page @ 2017-05-31 09:32 UTC (permalink / raw)
To: Surinder Kumar <[email protected]>; +Cc: pgadmin-hackers; Nigel Tucker <[email protected]>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-05-31 09:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-05-30 21:30 pgAdmin4 and boolean columns Nigel Tucker <[email protected]>
2017-05-31 05:05 ` Surinder Kumar <[email protected]>
2017-05-31 06:13 ` Surinder Kumar <[email protected]>
2017-05-31 09:25 ` Surinder Kumar <[email protected]>
2017-05-31 09:32 ` Dave Page <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox