Re: Assistance Required: Code Folding and Line Numbers Not Appearing in pgAdmin 4 (v9.8)

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Mas Kinato <mkinato(at)north(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org, security(at)pgadmin(dot)org, pgadmin-hackers(at)postgresql(dot)org, webmaster(at)pgadmin(dot)org
Subject: Re: Assistance Required: Code Folding and Line Numbers Not Appearing in pgAdmin 4 (v9.8)
Date: 2025-10-03 10:22:12
Message-ID: CAM9w-_mGnCSsKXoS7OkqXYsVFMewNKebNe_RBr0zAZXqpsvvqg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi Mas,

Please check - https://github.com/pgadmin-org/pgadmin4/issues/9160

On Thu, Oct 2, 2025 at 1:38 AM 'Mas Kinato' via pgAdmin Security <
security(at)pgadmin(dot)org> wrote:

> Dear pgAdmin Support Team,
>
> I am reaching out regarding an issue we are encountering with code folding
> in pgAdmin 4 (version 9.8).
>
> Issue Summary:
> • Code folding is enabled under Preferences → Query Tool → Editor (the
> “Code folding” option is toggled on).
> • However, fold carets/triangles are not appearing for foldable regions
> (e.g., WITH (…) CTEs or VALUES (…) blocks).
> • We only see the caret when wrapping a block in BEGIN…END;, but that
> makes the query invalid in SQL execution.
> • Additionally, the “Line numbers” option (expected under Preferences →
> Query Tool → Display) is missing entirely in this version of pgAdmin 4,
> which prevents us from exposing the gutter where fold carets normally
> appear.
>
> Steps Taken So Far:
>
> 1. Verified that Code folding is enabled.
> 2. Tried different themes (Default, Light, Dark) to check if the caret
> was hidden due to UI visibility.
> 3. Restarted Query Tool after preferences changes.
> 4. Tested simple foldable examples (e.g., WITH test AS (VALUES (1),
> (2), (3)) SELECT * FROM test;) — no fold caret appeared.
> 5. Confirmed with multiple users that the Line numbers preference is
> not visible in our pgAdmin 4 v9.8 builds.
>
> Environment:
> • pgAdmin 4 v9.8
> • Affected across multiple installations
> • OS: [insert OS details if you want to include, e.g., Windows 11 / macOS
> Sonoma]
>
> Request:
> Could you please confirm:
>
> 1. Whether the Line numbers option has been relocated or removed in
> pgAdmin 4 v9.8?
> 2. If this is a known regression/bug affecting code folding in CTEs
> and parentheses blocks.
> 3. Recommended steps or patches to restore proper code folding
> (without relying on BEGIN…END;).
>
> We rely on folding for large SQL queries, and currently this limitation
> makes navigation difficult. If this requires escalation, I’d be grateful if
> you could provide guidance or log it as a support issue with the pgAdmin
> development team.
>
> Thank you for your assistance.
>
> Best regards,
> Mas
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

Browse pgadmin-hackers by date

  From Date Subject
Next Message Aditya Toshniwal 2025-10-10 04:38:46 Translators: Release next week (v9.9)
Previous Message Dave Page 2025-09-30 08:10:33 Re: Regarding feature "Option to skip Password-Dialog for identity file"

Browse pgadmin-support by date

  From Date Subject
Next Message Marc Linster 2025-10-04 06:51:53 Strange benhavior of pgAdmin 9.8 on Windows
Previous Message jma 2025-09-29 13:01:04 Re: Debian package