Re: Expand/Collapse Nodes in Query Window

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 <cboorman(at)nabancard(dot)com> 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(dot)toshniwal(at)enterprisedb(dot)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(at)nabancard(dot)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(dot)toshniwal(at)enterprisedb(dot)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(at)nabancard(dot)com>
>>>> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> Please update me on this.
>>>>>
>>>>> Thanks,
>>>>> Cody
>>>>>
>>>>> On Tue, May 14, 2024 at 12:28 PM Cody Boorman <cboorman(at)nabancard(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> Just following up on this.
>>>>>>
>>>>>> On Mon, May 6, 2024 at 10:51 AM Cody Boorman <cboorman(at)nabancard(dot)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(dot)toshniwal(at)enterprisedb(dot)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(at)nabancard(dot)com> wrote:
>>>>>>>>
>>>>>>>>> Thanks! ETA on when that'll be released?
>>>>>>>>>
>>>>>>>>> On Tue, Feb 13, 2024 at 11:46 PM Aditya Toshniwal <
>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)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(at)nabancard(dot)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*
>>>>>>>>>> <https://www.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*
>>>>>>>> <https://www.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*
>>>> <https://www.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*
>> <https://www.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*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"