Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg24k-007AEN-56 for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Feb 2025 13:37:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tg24j-007Yin-8M for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Feb 2025 13:37:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg24i-007YiQ-Pm for pgadmin-hackers@lists.postgresql.org; Thu, 06 Feb 2025 13:37:49 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tg24g-003Wyv-0U for pgadmin-hackers@postgresql.org; Thu, 06 Feb 2025 13:37:47 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-30795988ebeso8554751fa.3 for ; Thu, 06 Feb 2025 05:37:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1738849064; x=1739453864; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=WqNTzI5wLPmgpQs23y74q/2zO6oV3Ra9B7fp3naVFDc=; b=AM+mnNF0kyHkaofYu8T3AyWG99yFhfPv0zG96ijj4Wn0RccjApOdOdOxvADXTcnyP+ WwFIHgai1Oeqea5MIlB+ATPyiaBJF5XcprGQLdmF6rTez2GzEsvZB0/+801N89B9ifRT QHiXijDU2V19UQKyEAmq3Xhl+TdKEkPUa8MAm0lLv6P50oaHvNZVygl4fEgdBgt65lXD 0fQCNSTIohjZtHQyEWDmMXbPye6nEVxZBfdNXdHdK0xKKPsF0ZUdcUz0Om+PR/IY8SMc Wfp4K+q4bNEMqToPAh36piaNT/YD1tHrEBBDjdXlK7Y0AnJevO/n0jvEjeOcPCiEH0yM kYng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738849064; x=1739453864; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=WqNTzI5wLPmgpQs23y74q/2zO6oV3Ra9B7fp3naVFDc=; b=mKLtsry3pr9Z1e4fdExd0JE+qrYk/E1EtWWFmR8FiHW9DaNeTTWBQIPm5jTv6ZLIaY THwgE4KxNIGIc06lFGXQ6YKJLfxwtqpBXbS+/YGRMT1M1cMcVV52n56uDfxsh9lTdECt xZ6+YyKibIHCnHYqfb9902giiIz7A6l9rxEbR+oChZvnwFVJvnSJprNGA8Saquvmoxao WVjzVY4/C3n+R8ioQyLdU10GQ9iqKxjkSXzDI3/9YJlFkghANQ+zYgjjfLXdTojJJpBA Qh8EHSASk39KepdF39oZhg6u3aiqMFAkC2ERpD6Irg114wGBXQIy5b3N350PZ99BOqMU BZTQ== X-Gm-Message-State: AOJu0YwM4UenhoAfNpSFTKLMzKwfickjjBnTDsxszrmIPhOj2ec8abpK mOwSZmnBg8e/5DX/kjfN3GDPhVJK1IfkF7+W60DStaBtV+/Ki0Rn1oAsQUH8TocbbtbJkZp5KEd TVWX5VC/tpNEAi82q0FjKZeg0ZK+vOb96wnpS1dT10c2qPw7mUdjD X-Gm-Gg: ASbGncvVTd2Ws90T+j4Ls6MEO36daQxv8O13/ViWjKNAe91Pa3iGJkDdWCwT4v1EBbZ RL11/o4A4rF8kMre5+m/vcsTi7xavje8zsqdl6fEBsRJFjgzZBJp0y0R+adGit7eWR795OCSLUA 32v53VhdRhlBvVKYIEQOUQGvcnkIZt0w== X-Google-Smtp-Source: AGHT+IHNGkXnch3tOaQQ2V9/yU6tLco9QjdwvJInot+IXchdWG1RBP5HkPwxXnqqeeIh/sZlGSV6DvlimR2jVktkq/M= X-Received: by 2002:a05:651c:1585:b0:2fb:cc0:2a05 with SMTP id 38308e7fff4ca-307cf38fa91mr26696781fa.37.1738849063781; Thu, 06 Feb 2025 05:37:43 -0800 (PST) MIME-Version: 1.0 From: Akshay Joshi Date: Thu, 6 Feb 2025 19:07:32 +0530 X-Gm-Features: AWEUYZnG91tiv1r2yrlTUwBEYJR2u_G3Vs-OUekZcWh_BA0IzrmYAsqawgzFwPI Message-ID: Subject: pgAdmin 4 v9.0 Released To: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000c3e448062d7958ee" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c3e448062d7958ee Content-Type: text/plain; charset="UTF-8" The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.0. This release of pgAdmin 4 includes 25 bug fixes and new features. For more details please see the release notes at: https://www.pgadmin.org/docs/pgadmin4/9.0/release_notes_9_0.html pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see: https://www.pgadmin.org/ Note: (Windows only) In this release, the 'vX' suffix has been removed from the application name. You will now see 'pgAdmin 4' as the app name. Starting from version 8, we also removed the 'vX' folder from the default installation path, allowing users to seamlessly upgrade to major versions. As a result of this change, if version 8 is already installed on the machine, the uninstaller will first run, followed by the installation of version 9. Notable changes in this release include: Features: - Enhanced pgAdmin 4 with support for Workspace layouts. Starting with this release, pgAdmin introduces two layout options: the Classic layout, a familiar design users know well, and the new Workspace layout, which provides a streamlined, distraction-free environment with dedicated areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace layout is set as the default, but users can easily switch to the Classic layout through the preferences. In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are organized and opened within their respective workspaces for a more focused experience. - Added the MAINTAIN privilege for PostgreSQL version 17 and above. - Add support for OAuth2 profile array response, which handles the GitHub Private Email ID issue. - Change button labels and color in the delete confirmation dialog for all objects to improve UX. Bugs/Housekeeping: - Fixed an issue where pgadmin cannot install into the path with non-ASCII characters. - Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost. - Fixed an issue where an error message from the database server needs space between two sentences. - Fixed an issue where the query tool throws utf-8 decode error when using a cursor with binary data. - Fixed an issue where the option key was not registering in the PSQL tool. - Fixed an issue where copying query tool output cell is not working if any SQL text is selected. - Remove the option "With no data (concurrently)" from the Refresh MATERIALIZED VIEW context menu. - Fixed an issue where Default Privileges and Privileges not working correctly. - Fixed an issue where quotes were missing in the CREATE script for the tablespace. - Change the logic of the setval function, so that the next nextval of sequence will return exactly the specified value. 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/ -- Akshay Joshi pgAdmin Project --000000000000c3e448062d7958ee Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

The pgAdmin Development Team is pleased to announce pgAdm= in 4 version 9.0.


This release of pgAdmin 4 includes 25 bug fixes= and new features. For more details please see the release notes at:=


=C2=A0=C2=A0=C2=A0=C2=A0https://www.pgadmin.org/docs/pgadmin4/9.0/release_notes_9_0.html


pgAdmin is the leading Open Source graphical management tool for= PostgreSQL. For more information, please see:


=C2=A0=C2=A0=C2= =A0=C2=A0https://www.pgadmin.org/


Note: (Windows only)

In this release, the 'vX' suffix h= as been removed from the application name. You will now see 'pgAdmin 4&= #39; as the app name. Starting from version 8, we also removed the 'vX&= #39; folder from the default installation path, allowing users to seamlessl= y upgrade to major versions.

As a result of this change, if= version 8 is already installed on the machine, the uninstaller will first = run, followed by the installation of version 9.


Notable changes = in this release include:


Features:

  • Enhanced pgAdmin = 4 with support for Workspace layouts.


    • = Starting with this release, pgAdmin introduces two layout options: the Clas= sic layout, a familiar design users know well, and the new Workspace layout= , which provides a streamlined, distraction-free environment with dedicated= areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace layou= t is set as the default, but users can easily switch to the Classic layout = through the preferences.

    In the Workspace layout, th= e Query Tool, PSQL, and Schema Diff tabs are organized and opened within th= eir respective workspaces for a more focused experience.


    • Added the MAINTAIN = privilege for PostgreSQL version 17 and above.

    • = Add support for OAuth2 profile array response, which handles the GitHub Pri= vate Email ID issue.

    • Change button labels and c= olor in the delete confirmation dialog for all objects to improve UX.


    Bugs/Housekeeping:

    • Fixed an issue where pgadmin= cannot install into the path with non-ASCII characters.

      • Fixed an issue where filter dialog save fails when the PostgreSQL= server/database connection is lost.

    • Fixed an= issue where an error message from the database server needs space between = two sentences.

    • Fixed an issue where the query t= ool throws utf-8 decode error when using a cursor with binary data.<= /p>

    • Fixed an issue where the option key was not registerin= g in the PSQL tool.

    • Fixed an issue where copyin= g query tool output cell is not working if any SQL text is selected.=

    • Remove the option "With no data (concurrently)&q= uot; from the Refresh MATERIALIZED VIEW context menu.

    • Fixed an issue where Default Privileges and Privileges not working c= orrectly.

    • Fixed an issue where quotes were = missing in the CREATE script for the tablespace.

    • Change the logic of the setval function, so that the next nextval of sequ= ence will return exactly the specified value.



    <= p dir=3D"ltr" style=3D"line-height:1.656;margin-top:0pt;margin-bottom:0pt">= Build= s for Windows and macOS are available now, along with a Python Wheel,

    Docker Container, RPM, DEB Package, and source code tarball from:

    = =C2=A0=C2=A0=C2=A0=C2=A0https://www.pgadmin.org/down= load/


    --

    Akshay Joshi

    pgAdmin Project

    <= /span>
    --000000000000c3e448062d7958ee--