Re: Some pgAdmin 4 (4.1) bugs

Hello Khushboo, thank you very much for your response!

On 29/01/2019 11.35, Khushboo Vashi wrote:
> Hi Arni,
>
> On Tue, Jan 29, 2019 at 3:24 PM Arni Kromić <arni(dot)kromic(at)bios-ict(dot)hr
> <mailto:arni(dot)kromic(at)bios-ict(dot)hr>> wrote:
>
> The new bug is in the UI, specifically in the query "window".
> While the
> lower half which contains "Data Output", "Explain" etc. can be
> undocked
> from its position and become a floating window, it cannot be docked
> back. If I undock single items ("DataOutput" etc.) from that window, I
> can dock them one by one back to the original position, but not the
> entire window.
>
>  
> This is the expected behaviour. 
>
> It's annoying because it can happen when you try to resize the top of
> the window; you can easily miss the thin line (changing cursor to
> double-arrow)
>
>
> We are working on this, please refer
> https://redmine.postgresql.org/issues/3865 
>
> and hit the "top bar" of that window and yank it out of
> its docking position - this is how I found out. Since it can't be
> returned to its original position as it is, you need to drag all four
> tabs one by one back to the position.
>
Actually, I don't mind much the thin resize-divider per se; I don't need
it too often. However I do mind that you cannot re-dock the lower window
after you undock it! It's definitely not "expected behaviour" in my book.

The mentioned issue does not cover this and I would like to log a new
report for it, because I definitely find it annoying and distracting...

> The other bug I've noticed before concerns the "Create - Sequence"
> functionality. If I enter a negative Increment, it complains:
> "Increment' must be greater than or equal to 1." Since Postgres does
> accept negative increments (i.e. descending sequences). This is
> strange,
> since descending sequences ARE mentioned in the help; if there is
> a way
> to specify them, I haven't found it...
>
> Please log the
> issue @ https://redmine.postgresql.org/projects/pgadmin4/issues
>  
Thanks, I'll do it as soon as I get to it.

> There is also a minor (possible) bug in the "Create - Function /
> Procedure" dialog - when you enter code in the window, the
> resulting SQL
> is something like "AS $BODY$select this from that$BODY$;". While it
> doesn't affect functionality, the readability of the CREATE code
> is, so
> I prefer to put newlines on the first and last lines of Code input.
> There is one example where the code is somewhat messed up though, and
> that's when the last line of code is a comment. Then the resulting SQL
> contains something like this:
>
> AS $BODY$select this from that
> --comment$BODY$;
>
> The closing $BODY$ thus gets commented out.
>
> This one is already logged. https://redmine.postgresql.org/issues/3851
That's great, I look forward for the fix.
>  
>
> Another glitch new to 4.1 is that SQL tab is not visible when a new
> "Create - Function / Procedure" window is open - it has to be
> widened a
> bit for that tab to show. Also there is no indication that tab
> exists -
> if I didn't expect it to be there, I wouldn't've even tried
> looking for it.
>
> This issue has already been fixed and will be available in the next
> release.
Excellent, thanks!
>
> Please tell me if those issues should be or have been reported, and
> should I do it (and where) or someone else would. Thank you for your
> patience!
>
> --
> Kind Regards,
> Arni Kromić
>
> Thanks,
> Khushboo 

--
Kind Regards,
Arni Kromić