Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qT1nU-0089GB-39 for pgadmin-hackers@arkaria.postgresql.org; Mon, 07 Aug 2023 15:05:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qT1nR-00ADDe-PN for pgadmin-hackers@arkaria.postgresql.org; Mon, 07 Aug 2023 15:05:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qS3Sc-00BJEw-KA for pgadmin-hackers@lists.postgresql.org; Fri, 04 Aug 2023 22:39:55 +0000 Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qS3SZ-000ZYP-8z for pgadmin-hackers@postgresql.org; Fri, 04 Aug 2023 22:39:53 +0000 Received: by mail-lj1-x230.google.com with SMTP id 38308e7fff4ca-2b9c0391749so43259791fa.0 for ; Fri, 04 Aug 2023 15:39:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mccright-com.20221208.gappssmtp.com; s=20221208; t=1691188789; x=1691793589; h=cc:to:subject:message-id:date:thread-index:mime-version:in-reply-to :references:from:from:to:cc:subject:date:message-id:reply-to; bh=Q0BvHQRi4155tjCeAOsATWHxgxAcrdAtbkCqjDPnIgE=; b=QRFPbIZKl5YTRHz8fp84/nDSUUukFakn6BAfNkMrm+QMiaCRXIEWstZtvCRZl0FuXD 4HGw/+iQMU8YNztGRTAy9BroZbNgXnXvUyYD06GLa4nVENP06tf/QxAoz7XMvtZwkVaD 3Y3OsFVF7m4RZEe6X/kiJm+o+THz4KVlzIjKwHv4sUVTpc4dWM3dOb5BQcX3qJR7RVeF LRd9zXdfWpdiq7v+CqeQlFBY2R9jOQpYtaWOPeiflKxRb0OdTq5AfftGAdFx4Bd/25SZ YY0GKrqC427QaRiOBd7+86sv4mkh5zFRsjkpw7TMPSOY3Fs/Txqu5yWqM1pchT6lpEEv uW5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691188789; x=1691793589; h=cc:to:subject:message-id:date:thread-index:mime-version:in-reply-to :references:from:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Q0BvHQRi4155tjCeAOsATWHxgxAcrdAtbkCqjDPnIgE=; b=LbhQeQ0SBXOVkB0isnDzwI7kTNHxIAjV5hMkgRWDubArDz7OxrmhlHI9YuJFdCNw7z icVrI11L2oOv6JF0qGSr2N8uf9E+bbk0Aw1ckiEPW2BF89zu17Qw9kbzXcIxjsrn9tMu cI3nTIPO2HpCOoPNVYQ8KQ/ZWjBGfUUfXKS3bukus3bGEWoIOxy15FWTJFR4DMCd535r DE2mwWZWTVSAPO8Af7mcSHlTSVwM5FQ2ancWq5J2gT2N6NgXjFt5FE6YTXTW7B3OCvaj W725P0srjwkHK1YXhKMufSArfjJaPXQShPkUl1SLjqfBw9y/YpcMq8T9qLuqWQsWiAvv 8tug== X-Gm-Message-State: AOJu0YyN+/3JedOUYT2pHKKQ5oavNq2a0gPvMqg3O0hVo6ERcN0TRHqU G/zMC2cDWfLxTtMHFn1Z+mIGQnl2qZuBTOoaCPbyVl+poG7R2mRC X-Google-Smtp-Source: AGHT+IFtP47lmZXI6nB+FbT/uRfCGSVZqQ+3N1LlqBRxM5tg/aQjeJ2hXEjmwjX1QhclZtETXg7d81N5eNMgf3kjK1k= X-Received: by 2002:a05:651c:1030:b0:2b6:a05a:c5c with SMTP id w16-20020a05651c103000b002b6a05a0c5cmr2576812ljm.1.1691188789436; Fri, 04 Aug 2023 15:39:49 -0700 (PDT) From: Sandy Haas References: <5201fc200379e3e6192139b2bf561491@mail.gmail.com> In-Reply-To: MIME-Version: 1.0 X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQJM2e3QQ+UqPOYjwnucykC21RI4kAEJ6V30Ab2oo+MCETPnqq7NzwxA Date: Fri, 4 Aug 2023 18:39:47 -0400 Message-ID: <05cb2cbc280eb0776fadc2b2133f0d83@mail.gmail.com> Subject: RE: Saved SQL queries will not execute To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000000af76806022093a5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000af76806022093a5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable That seems to have fixed it. Thank you!!! thank you, ~sandy *From:* Aditya Toshniwal *Sent:* Wednesday, June 21, 2023 10:26 AM *To:* Sandy Haas *Cc:* pgadmin-hackers *Subject:* Re: Saved SQL queries will not execute Hi Sandy, Can you check if auto complete of key press is enabled in Preferences Query Tool? If enabled, please try disabling it and open new query tool. On Wed, Jun 21, 2023, 19:22 Sandy Haas wrote: Attached is the log file for the following example of what is happening. I open the query tool once I=E2=80=99m connected to my database. [image: A screenshot of a computer Description automatically generated with medium confidence] I open my saved query from a folder in my dropbox and update my parameters and click execute. [image: A screenshot of a computer screen Description automatically generated with low confidence] Then I change my parameters, click save, and execute, and nothing updates. I have to copy my query to a new query window for it to actually update the records. [image: A screenshot of a computer Description automatically generated with medium confidence] These are my settings. [image: A screenshot of a computer Description automatically generated with medium confidence] thank you, ~sandy *From:* Aditya Toshniwal *Sent:* Tuesday, June 20, 2023 8:29 AM *To:* Sandy Haas *Cc:* pgadmin-hackers@postgresql.org *Subject:* Re: Saved SQL queries will not execute Hi Sandy, What is the error when it does not work? Can you share screenshot or pgAdmin logs as well please? On Sat, Jun 17, 2023 at 12:11=E2=80=AFAM Sandy Haas w= rote: Good morning, I=E2=80=99m hoping someone can help me with a problem I seem to be having w= hen trying to run saved queries on my new Windows 11 PC. When I open a saved query, and execute it, sometimes it works, but most times it does not. I=E2=80=99m having to copy the query and paste it into = a new query tab and execute it that way. Then, if I change a variable in that query, I have to again copy it, and paste it into yet another query tab, to get it to execute. I recently got a new PC, Windows 11, and am using version 7.3. I=E2=80=99ve scoured the web and the PGAdmin documentation, and the only th= ing I=E2=80=99ve found referencing issues, is to check that auto commit is on, and it is. I did install it to my D drive, but I notice that the Database File is located on my C drive. Could this possibly be the issue? Any help is greatly appreciated. Sincerely, Sandy Haas Logistics/Data Management Special Projects sandyh@mccright.com 423-468-1634 (O) 423-413-7362 (C) [image: Celebrating-25-Years-w-Logo (2)] --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --0000000000000af76806022093a5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

That seems to have fixed it.=C2=A0 Thank yo= u!!!

=C2=A0<= /span>

thank you,

~sandy=

=C2=A0

<= div style=3D"border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0= in 0in">

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.co= m>
Sent: Wednesday, June 21, 2023 10:26 AM
To: = Sandy Haas <sandyh@mccright.com>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Subject: R= e: Saved SQL queries will not execute

=C2= =A0

Hi=C2=A0Sandy,

=C2=A0

Can you check if auto com= plete of key press is enabled in Preferences Query Tool?

If enabled, please try disabling it and open new query t= ool.

=C2=A0

On Wed, Jun 21, 2023, 19:22 Sandy Haas <sandyh@mccright.com> wrote:

<= /div>

Attached is the log file for the following e= xample of what is happening.

=C2=A0

I open the query tool = once I=E2=80=99m connected to my database.

3D"A

=C2=A0

I open my saved query from a folder in m= y dropbox and update my parameters and click execute.

3D"A

=C2=A0

<= p>=C2=A0

Then I change my parameters, c= lick save, and execute, and nothing updates.=C2=A0 I have to copy my query = to a new query window for it to actually update the records.

<= img border=3D"0" width=3D"558" height=3D"384" style=3D"width:5.8125in;heigh= t:4.0in" id=3D"_x0000_i1027" src=3D"cid:image003.png@01D9A426.0F7E53B0" alt= =3D"A screenshot of a computer Description automatically generated with medium confidence">

=C2=A0

=C2=A0

These are my settings.

3D"A

=C2=A0

=C2=A0

thank yo= u,

~sandy

=C2=A0

From= : Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sen= t: Tuesday, June 20, 2023 8:29 AM
To: Sandy Haas <sandyh@mccright.com&g= t;
Cc: pgadmin-hackers@postgresql.org
Subject: Re: Saved= SQL queries will not execute

=C2=A0

Hi=C2=A0Sandy,=

=C2=A0

What is the error when it does not work= ? Can you share screenshot or pgAdmin logs as well please?

=

=C2=A0

On Sat, Jun 17, 2023 at 12:11= =E2=80=AFAM Sandy Haas <sandyh@mccright.com> wrote:

Good morning,

=C2=A0

I=E2=80=99m hoping someone can help me with a problem I seem= to be having when trying to run saved queries on my new Windows 11 PC.

=C2=A0

When I open a saved query, and execute it, somet= imes it works, but most times it does not.=C2=A0 I=E2=80=99m having to copy= the query and paste it into a new query tab and execute it that way.=C2=A0= Then, if I change a variable in that query, I have to again copy it, and p= aste it into yet another query tab, to get it to execute.

=C2=A0

I recently got a new PC, Windows 11, and am using version 7.3.=

=C2=A0

I=E2=80=99ve scoured the web and the PGAdmin= documentation, and the only thing I=E2=80=99ve found referencing issues, i= s to check that auto commit is on, and it is.

=C2=A0

I did install it to my D drive, but I notice that the Database File is loc= ated on my C drive.=C2=A0 Could this possibly be the issue?

=C2=A0

Any help is greatly appreciated.

=C2=A0

=C2=A0

=C2=A0

=

Sincerely,

=C2=A0

Sandy Haas

Logistics/Da= ta Management

Special Projects

sandyh@mccrigh= t.com

423-468-1634 (O)

<= p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-al= t:auto">423-413-7362 (C)

<= img border=3D"0" width=3D"207" height=3D"72" style=3D"width:2.1562in;height= :.75in" id=3D"_x0000_i1025" src=3D"cid:image005.jpg@01D9A426.0F7E53B0" alt= =3D"Celebrating-25-Years-w-Logo (2)">

=C2=A0


=C2=A0

--

Thanks,

Aditya Toshniwal

<= div>

pgAdmin Hacker=C2=A0| Sr. So= ftware Architect=C2=A0| enterprisedb.com

"Don't Complain ab= out Heat, Plant a TREE"

=
--0000000000000af76806022093a5--