Re: Expand/Collapse Nodes in Query Window - Mailing list pgadmin-support

I don't have access to a github account with my organization. Can you please add to the ticket on my behalf? I've copy/pasted a recap of the issue along with two screenshots below:

I'm having some trouble opening and saving SQL files. I tried changing the default program to open SQL files as SQL but it still gives me the same error which I've attached here. As you can also see from the first screenshot, the icon is coming through as a .txt file by default as well.

Because of this, I am unable to save SQL files or open them directly in pgadmin. I have to use a workaround of copy/pasting into pgadmin, changing my dates and then copy/paste back into the text file and save but there's some issues with this.

IT at NAB wasn't able to figure it out and remoted in to both my system and my manager's system to see if there were any differences in settings but couldn't find any. Would you be able to look into this further? I am using version 1.22.2.

Thanks,
Cody

On Mon, Jun 17, 2024 at 8:52 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Cody,

The code folding in pgAdmin currently is not really in a very good state due to an upgrade of an underlying package(CodeMirror). We're continuously working to make it better. What you can do is mention your suggestion on the ticket I mentioned.

On Mon, Jun 17, 2024 at 7:55 PM Cody Boorman <cboorman@nabancard.com> wrote:

Hello, that looks to be referring to just begin/end if statements. I'm referring to any long list of data being selected in a parentheses (ie, WHERE ID Number IN (a, b, c, d, etc) where there might be hundreds or thousands of items. PGAdmin 3 used to have an expand/collapse button so you can see your code more clearly by collapsing the list of IDs found in the where clause and PGAdmin 4 doesn't have the expand/collapse buttons.

On Sun, Jun 16, 2024 at 10:38 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Cody,

You can track - https://github.com/pgadmin-org/pgadmin4/issues/7280

On Fri, Jun 14, 2024 at 7:20 PM Cody Boorman <cboorman@nabancard.com> wrote:

Hello,

Please update me on this.

Thanks,

Cody

On Tue, May 14, 2024 at 12:28 PM Cody Boorman <cboorman@nabancard.com> wrote:

Hello,

Just following up on this.

On Mon, May 6, 2024 at 10:51 AM Cody Boorman <cboorman@nabancard.com> wrote:

Hello,

Looks like this is still happening with the most recent version. Is this known?

On Mon, Feb 19, 2024 at 2:25 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Cody,

pgAdmin does a release every month. So it would be in the week of 7th March.

On Wed, Feb 14, 2024 at 9:17 PM Cody Boorman <cboorman@nabancard.com> wrote:

Thanks! ETA on when that'll be released?

On Tue, Feb 13, 2024 at 11:46 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Cody,

This is a known bug. It will be fixed in the next release of v8.4.

On Tue, Feb 13, 2024 at 3:21 PM Cody Boorman <cboorman@nabancard.com> wrote:

Hello,

I just transitioned to PGAdmin 4 and I don't see the expand/collapse nodes for items in parenthesis that PGAdmin 3 had in the query window so you can minimize large scripts that had a lot of data in the WHERE clause. I have version 7.8 but I spoke to our DBA who had the latest 8.3 version and they weren't appearing for him either.

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

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

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

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

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

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

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

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

--

Cody Boorman

Financial Analyst

North American Bancard

250 Stephenson Hwy, Troy, MI 48083