Re: Expand/Collapse Nodes in Query Window

[Cody Boorman]

I am aware of that. I said this feature was available in pgadmin 3. I was
also told it was put into pgadmin 4 but there was a technical issue with it
that was going to be patched with the most recent version. That didn't
happen. Can you please include my recap on my prior email in that thread?

On Mon, Jun 17, 2024 at 10:57 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Cody,
>
> pgAdmin 3 is not supported. Only latest version of pgAdmin 4 is supported.
>
> On Mon, Jun 17, 2024 at 8:49 PM Cody Boorman 
> wrote:
>
>> 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.toshni...@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 
>>> 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.toshni...@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 
> wrote:
>
>> Hello,
>>
>> Please update me on this.
>>
>> Thanks,
>> Cody
>>
>> On Tue, May 14, 2024 at 12:28 PM Cody Boorman 
>> wrote:
>>
>>> Hello,
>>>
>>> Just following up on this.
>>>
>>> On Mon, May 6, 2024 at 10:51 AM Cody Boorman 
>>> 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.toshni...@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 <
> cboor...@nabancard.com> wrote:
>
>> Thanks! ETA on when that'll be released?
>>
>> On Tue, Feb 13, 2024 at 11:46 PM Aditya Toshniwal <
>> aditya.toshni...@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 <
>>> cboor...@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 

Re: Expand/Collapse Nodes in Query Window

[Aditya Toshniwal]

Sure I will do that.

On Tue, Jun 18, 2024 at 6:41 PM Cody Boorman  wrote:

> I am aware of that. I said this feature was available in pgadmin 3. I was
> also told it was put into pgadmin 4 but there was a technical issue with it
> that was going to be patched with the most recent version. That didn't
> happen. Can you please include my recap on my prior email in that thread?
>
> On Mon, Jun 17, 2024 at 10:57 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Cody,
>>
>> pgAdmin 3 is not supported. Only latest version of pgAdmin 4 is supported.
>>
>> On Mon, Jun 17, 2024 at 8:49 PM Cody Boorman 
>> wrote:
>>
>>> 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.toshni...@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 
 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.toshni...@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 
>> wrote:
>>
>>> Hello,
>>>
>>> Please update me on this.
>>>
>>> Thanks,
>>> Cody
>>>
>>> On Tue, May 14, 2024 at 12:28 PM Cody Boorman <
>>> cboor...@nabancard.com> wrote:
>>>
 Hello,

 Just following up on this.

 On Mon, May 6, 2024 at 10:51 AM Cody Boorman <
 cboor...@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.toshni...@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 <
>> cboor...@nabancard.com> wrote:
>>
>>> Thanks! ETA on when that'll be released?
>>>
>>> On Tue, Feb 13, 2024 at 11:46 PM Aditya Toshniwal <
>>> aditya.toshni...@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 <
 cboor...@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
>


 --