Re: Result grid rendering (was: Re: [pgAdmin4][Pattch] - RM #3673 - "Download as .csv" F8 does NOT work when one of joined files is a TEMPORARY file)

From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Result grid rendering (was: Re: [pgAdmin4][Pattch] - RM #3673 - "Download as .csv" F8 does NOT work when one of joined files is a TEMPORARY file)
Date: 2019-03-04 06:49:08
Message-ID: CAFOhELft_ys1tvvN9Qh+mgkxxYTMzXzRq1-Y7Jb3OqfZ44f0dQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Fri, Mar 1, 2019 at 6:19 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> On Fri, Mar 1, 2019 at 5:39 AM Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> Hi Dave,
>>
>> Please find the attached fix.
>>
>> Thanks,
>> Khushboo
>>
>>
>> On Thu, Feb 28, 2019 at 6:58 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Hi
>>>
>>> On Thu, Feb 28, 2019 at 3:46 AM Khushboo Vashi <
>>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Dave,
>>>>
>>>> On Wed, Feb 27, 2019 at 4:30 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> Thanks - that fixed the double scrollbar, but not the other issue. Any
>>>>> ideas on that one?
>>>>>
>>>> Can you please provide the exact steps to reproduce the second issue as
>>>> after fixing the first one I can't reproduce it.
>>>>
>>>
>>> Sure - movie seems easiest, so grab some popcorn and put the attached on
>>> the big screen!
>>>
>> Unfortunately, I don't have a big screen, so I missed the opportunity to
>> have popcorn. :)
>>
>
> Booo :-(
>
> Well, anyway - the sizing issue seems OK now, but if I have a table (id
> serial primary key, data text) with enough rows that I need to scroll, when
> I scroll to the end I can edit the id field in place, but the text editor
> popup doesn't show up. If I try to edit a row further up, it seems to
> appear in a weird place, so I suspect it's just rendering off-screen.
>
> I think we should render it directly against the cell - above if the cell
> is >50% down in the overall screen, else above, and something similarly
> sane for the left/right.
>
> Not sure if this is a regression or not, but it's unusable as-is, so can
> you fix that too? I'll commit your current patch.
>
> I couldn't reproduce the issue, however, I found that the position of the
text area was not appropriate.
To fix this, I have applied below logic.

Textarea Top = Current Cell Top - Text area Height

So, in this case, the text area bottom would align with the cell itself.

Please find the patch along with the screen-shots.

Thanks!
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Attachment Content-Type Size
text_editor_position_fix.patch application/octet-stream 977 bytes
Text_editor_current_position.png image/png 496.5 KB
Text_editor_after_applying_patch.png image/png 507.3 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2019-03-04 07:36:36 pgAdmin 4 commit: Update documentation screenshots as per new design. F
Previous Message Khushboo Vashi 2019-03-04 05:43:21 Re: Async queries pretending to be synchronous