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 <cboor...@nabancard.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.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 <cboor...@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.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 <cboor...@nabancard.com> >>>> 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 >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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"