pgAdmin 4 v9.3 Released

[Aditya Toshniwal]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.3.
This release of pgAdmin 4 includes 4 new features and 14 bug
fixes/housekeeping changes. For more details please see the Release Notes
.

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see https://www.pgadmin.org/

Notable changes in this release include:

New features

   -

   Add support for type constructors for PostGIS spatial types.
   -

   Added ability to use SQL in the "DB Restriction" field.
   -

   Add support for custom roles and role permissions management in pgAdmin.
   -

   Added support for font ligatures.

Bug fixes

   -

   Add Cache-Control no-cache,no-store,must-revalidate header to
   dynamically generated utils.js file.
   -

   Fixed an issue where shift + click on rows/columns for range selection
   did not work in the query tool data output window.
   -

   Fixed an issue where the debugger hangs when stepping into nested
   function/procedure.
   -

   Ensure that graph data is updated even when the Dashboard tab is
   inactive.
   -

   Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows.
   -

   Fixed an issue where drag and drop function with no parameters does not
   work.
   -

   Fixed an issue where changes to foreign key constraints were not
   detected in the schema diff.
   -

   Fixed an issue where the query tool went blank when converting history
   dates to the appropriate locale format.
   -

   Fixed an issue where the user management tab is not opening in the
   classic layout.
   -

   Allow OAuth 2 login using the username claim if the email is absent from
   the user profile.

Builds for Windows and macOS are available now, along with a Python Wheel,
Docker Container, RPM, DEB Package, and source code tarball from:
https://www.pgadmin.org/download/

--
Aditya Toshniwal
pgAdmin Project

Re: Two crippling visual bugs about pgAdmin 4: flashing white backgrounds and blinking carets.

[Aditya Toshniwal]

Hi,

On Wed, Apr 30, 2025 at 4:01 PM mullvadisen  wrote:

> I'm using pgAdmin 4 on Linux (X11, Plasma, desktop mode, Debian, obtained
> from pgAdmin's custom APT repository). Naturally, because I value my
> eyesight and sanity, I use the dark mode. Recently, it has started doing
> something horrible:
>
> 1. Every time you open any new "view" inside the application, it flashes
> the screen bright white before rendering the new page. For example if you
> click the "Query Tool" button. It happens every single time, and was sadly
> not fixed in 9.3 which was just released and which I was hopeful for. This
> drives me insane and it didn't use to happen.
>

You can create a bug on github.

>
> 2. The program doesn't respect my system settings to not blink the caret
> in text inputs. It keeps blinking even though I've set it to not blink (be
> fixed as visible) in the KDE settings. This "animation" makes it impossible
> for me to use the program; I'm forced to write any query etc. in a separate
> Kate text document (where the caret doesn't blink) and then paste it into
> pgAdmin 4, because having the pgAdmin 4 window up and working in it becomes
> impossible due to this "Caret from Hell".
>

You can create a feature request on github.

>
> I've looked all over the GUI settings and searched online for some hidden
> config option to turn this infernal blinking off, but there is just nothing
> (that I can find after spending countless hours). Please enable this
> somehow so that people whose brains will never be compatible with stuff
> moving around or animating on the screen can also use this crucial
> software. It has overall massively improved in recent years, but these two
> things sadly really drag it down again.
>
> PS: I'm aware that pgAdmin 4 uses Chromium which uses some custom
> rendering engine from Google, which would maybe explain why it doesn't care
> about any of my system settings, but nevertheless they cannot have been
> sadistic enough to *hardcode* the cursor to blink? Words cannot describe
> how distracting and stressful that is.
>
> PS 2: I'm sending this to this e-mail list because you use Github for
> filing "Issues", and Github doesn't allow account registration ever since
> they sold out to Microsoft. (No, I'm not making that up. It's been the same
> every single time I've tried over the years. It consistently refuses, like
> all major websites today.)
>

I don't think that is the case, people have created so many Github accounts
after that (including me). Even then if you're not able to create one then
let us know, we'll create the bug on your behalf.

>
> I'm not even sure I'll be able to respond to anything here. I might have
> to passively read any responses through the web archive depending on how
> many further hurdles there will be to actually posting/sending this...
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Two crippling visual bugs about pgAdmin 4: flashing white backgrounds and blinking carets.

[mullvadisen]

I'm using pgAdmin 4 on Linux (X11, Plasma, desktop mode, Debian, obtained from 
pgAdmin's custom APT repository). Naturally, because I value my eyesight and 
sanity, I use the dark mode. Recently, it has started doing something horrible:

1. Every time you open any new "view" inside the application, it flashes the 
screen bright white before rendering the new page. For example if you click the 
"Query Tool" button. It happens every single time, and was sadly not fixed in 
9.3 which was just released and which I was hopeful for. This drives me insane 
and it didn't use to happen.

2. The program doesn't respect my system settings to not blink the caret in 
text inputs. It keeps blinking even though I've set it to not blink (be fixed 
as visible) in the KDE settings. This "animation" makes it impossible for me to 
use the program; I'm forced to write any query etc. in a separate Kate text 
document (where the caret doesn't blink) and then paste it into pgAdmin 4, 
because having the pgAdmin 4 window up and working in it becomes impossible due 
to this "Caret from Hell".

I've looked all over the GUI settings and searched online for some hidden 
config option to turn this infernal blinking off, but there is just nothing 
(that I can find after spending countless hours). Please enable this somehow so 
that people whose brains will never be compatible with stuff moving around or 
animating on the screen can also use this crucial software. It has overall 
massively improved in recent years, but these two things sadly really drag it 
down again.

PS: I'm aware that pgAdmin 4 uses Chromium which uses some custom rendering 
engine from Google, which would maybe explain why it doesn't care about any of 
my system settings, but nevertheless they cannot have been sadistic enough to 
*hardcode* the cursor to blink? Words cannot describe how distracting and 
stressful that is.

PS 2: I'm sending this to this e-mail list because you use Github for filing 
"Issues", and Github doesn't allow account registration ever since they sold 
out to Microsoft. (No, I'm not making that up. It's been the same every single 
time I've tried over the years. It consistently refuses, like all major 
websites today.)

I'm not even sure I'll be able to respond to anything here. I might have to 
passively read any responses through the web archive depending on how many 
further hurdles there will be to actually posting/sending this...