Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBaUj-0005EE-3x for pgadmin-hackers@arkaria.postgresql.org; Tue, 20 Jun 2023 12:30:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBaUh-0005xe-Q9 for pgadmin-hackers@arkaria.postgresql.org; Tue, 20 Jun 2023 12:29:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBaUh-0005vE-GR for pgadmin-hackers@lists.postgresql.org; Tue, 20 Jun 2023 12:29:59 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qBaUd-003cf5-LM for pgadmin-hackers@postgresql.org; Tue, 20 Jun 2023 12:29:58 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-55e52ba9245so1165154eaf.3 for ; Tue, 20 Jun 2023 05:29:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1687264193; x=1689856193; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UBGObmBX97ayUQdTsmZtOCj7Nnl2NrycdhRzkoXsi1s=; b=lLxQqFDvSamkNssd0BVqeyLsVQhZBnkeyXWEeakCdGPdr+e5YRxvtOOKxrWZgLj3d+ sm/6LhsGetUO+BtaH7/d6VylaWgB0cG8jt1p3xRKwSUmHsZhM1wvClv2RV85xiromHzO H2/odIuIPY4IwVissF58A7j8cqByS6r64Heh/YCkIj5Bg45YxQkXaAo7a4jfLYVl3jaC NjF93Ta91rDCgceJCIekfZGs+RHSRuOcFuBM0q0R4/juegwAaII4uUzj64MCsiz6iD6k lVlRFwqWKylES4oFN+40cSAQlXLXIJI10IC0n/HgBSdAdB0jmQ4xL+CLtMKklaX4ADR3 D5dQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687264193; x=1689856193; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=UBGObmBX97ayUQdTsmZtOCj7Nnl2NrycdhRzkoXsi1s=; b=CaIi81tqCuZz0XFbWg5vA/gusrs6j0wu3ViYg7Wl7uyWGcMTmahYM5+WevoyqBBfqz 791fHlXeSXJ1aZqZ6bqDd5BYXNdZfUcbjDYctkTGFi8lwdyp8TTAr1MGyhq3AHRnWbso DLXliX5hS6PrjNzppsDeLXMv9wPo3inDCwcDLd0ttm5lDl4jTRrUAh20tpUrpRUHmV+N cUD1mSQh52RzdMJoO2p/mKVBy9zcmRakmZ91kZjm2perRFKXrZKo5UoMe+1k/LHxuMMi YP4svN+Qqu9gaYvf0LjJRoCIwQNPKzy9YSbfKYT6rBRDxxnVc4GdIliKIjPFLnZV5qnZ MhDQ== X-Gm-Message-State: AC+VfDwLQ57kta3OniiMJdlk4BfE1CF+jeLtAb5tEHjVimY0hKInbYfX U1CkhMrG1An+/2z//UbvVGsJs3ijgqdb60iF1rRGA4iJM9D9syYs X-Google-Smtp-Source: ACHHUZ4aL6SqWjCER0mced4kVxcVem9HV4CEa8PYDj4qlrV1CNUOO1c873HDHgiQvKpDki9KmSBiO3X2R6im8rPbypI= X-Received: by 2002:a05:6808:14c4:b0:39e:dbe8:2007 with SMTP id f4-20020a05680814c400b0039edbe82007mr5185506oiw.25.1687264193427; Tue, 20 Jun 2023 05:29:53 -0700 (PDT) MIME-Version: 1.0 References: <5201fc200379e3e6192139b2bf561491@mail.gmail.com> In-Reply-To: <5201fc200379e3e6192139b2bf561491@mail.gmail.com> From: Aditya Toshniwal Date: Tue, 20 Jun 2023 17:59:17 +0530 Message-ID: Subject: Re: Saved SQL queries will not execute To: Sandy Haas Cc: pgadmin-hackers@postgresql.org Content-Type: multipart/related; boundary="000000000000e47d5605fe8ece1b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e47d5605fe8ece1b Content-Type: multipart/alternative; boundary="000000000000e47d5505fe8ece1a" --000000000000e47d5505fe8ece1a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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= when > 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 int= o 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 = thing > 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" --000000000000e47d5505fe8ece1a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Sandy,

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

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

G= ood morning,

=C2=A0

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

=C2=A0

When I open a saved= query, and execute it, sometimes 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 paste 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, is to check that auto commit is on, and it = is.

=C2= =A0

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

=C2=A0

Any help is greatly appre= ciated.

=C2=A0

=C2=A0

= =C2=A0

Sincerely,

=C2=A0

Sandy Haas

Logistics/Data Management

Special Proje= cts

sandyh@mccright.com

<= p class=3D"MsoNormal">423-468-1634 (O)

423-413-7362 (C)

3D"Celebrating-25-Years-w-Logo

=C2=A0



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Sr. Software Architect=C2=A0| enterprisedb.com
X-Attachment-Id: 66d5215752ed5ae2_0.1 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCABIAM8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2aiii gDnNW8daBoeoPYX908dxGAWURM3BGRyBV/QvEOm+IrWS502ZpY432MWQrzgHv9a8b+KP/I93f/XO P/0AV0Hw48R6Z4c8JX1xqNyIybs7Ixy8nyL0H+RXVKivZqS3I5tT1eivHLn4v6s2rrPb2kK2CHBt n5Zx6lux+nH1r0Xw34w0nxPDmzm2XCjMltIcOv8AiPcVlOjOCu0NSTN+ikzS1kUFFFFABRRRQAUU UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFNZ1RS7MFVRkknAFOrE8ReGofEtqlrc3t7bwKSXjt pFUS9PvZU5xjimrX1A8a+IWoWmp+Mbu5sp1nhwih0+6SFAOPX61zNafiTTIdH8Q3unW7yPFby7Ea QgsRgdcAD9KzK9eCSirGD3CpIJ5rWdJ7eV4pYzlHRtrKfYjpUdSW1tPeXCW9tC80rnaiRqSSfpTE eneFPixgJZ+Ihnst4i/+hgfzH5V6fBcQ3UCT28qSxSDKujAhh7EV853Ph7UdL1W2sdWtJbYzuq5I HIJGcHocZr2/w34NtfC8jmx1DUJIpBzBPIrR59QAowfeuCvCC1iaxbOioriPidf65ofhx9a0bV5b R4GRGgEEciybmxnLKSDz64rZ8GeIo/FPhiz1RSvmuu2dR/BIPvD8+foRXKWbtLWdrmr2+haJeapc /wCqtYi5Gcbj2Ue5OB+NcX8Kte17xVa3up6vqssgguGhW1WCJEHAPJC7uM+tAHotFJS0AJRmuB1D xbqviDxjJ4W8KyR24s8m/wBSkjEnlYOCqKeCc8c989hmtC/0PxXp1lJdaR4nuL25iQsLe+t4mSYg dAVVSp9OTQB12aWszw5c3V34a0u5vizXU9nFJOWXaS5QFuO3OeK0qAForndJh8VJ4p1OTVLq1k0Z h/oUcagOnPfjPTOck89K6GgBaKK8yurjVNO+Oel6Z/bN9NYXsEl01tJKfLUlJhtCjggbARmgD02k pa5zxj4vt/B1jbXM9rJc/aZxAiowXBIJyc/SgDo6KKKACiiigD548df8jtqv/Xwf5VgVv+Ov+R21 X/r4P8qp6HqWn6Xd/ab3SV1JlPyJLLtRfqMHP8q9ePwIwe5qeF/AWreJWWZU+y2Pe4lXr/uj+L+X vXsfh3wnpPhm32WMGZmGHuJOZH/HsPYVm+BfGT+LReq1gloLTy8BJN2d272GPu111cFapNvlehrF K2hWu7G1v4RDd26ToGDAOucEdCPQ1ZoornKOX+IG0eHoC2Ao1G0znpjz0zXHeHWPw++KN14bkOzS daPnWWT8qOc7QPxynv8ALXQ/E/UreLQorDbLJcSXMEoSOF3wiyBmOQD2HTrVb4laKvizwdFrOkF3 vNOb7RbOqsrso+8oBwc8AjjOVHrQBoa5/wAVJ4zsfD4+ay0zF/qGOjPn9zGfxyxHoBWH8EP+QHrP b/iZN/6CtbvhGCTQPC0mteIHYX+ov9rvpPLJILYCJtAJ+UbRjHHNc58F7lLW01PT7hJobme8aeNJ IHXcm0DOSMdumc0AL4Xih+J+saprGtFrnSrSfyLCxLkRDjO9gDy2Mfmfauh8G+GdX8N6xrCTXcTa NNLusLVHY+SuTxg/dwCBx161yfhq4uPhVrGp6Vq9hdPotzN51rfQQmRR2w2O+MD1BHcHNd9oOvXf iC8luINPltdISPEct1EY5Z5M8lVJ4QDuRyTx0NAHAfAc+b/wkFxNk3TzReaSOed5/nmvXa80/sXU fh943vNb0+xnv9B1Xm6itk3y2z5zu29SoJPToGPoM7uoeO7eawlTw7aX2pag0Z8qNLORFRiOC7Oo CgH8aAOb+ONpFb6Lp+sK0wnS8SAqJSFZNrsQV6ZyBzW5Y/D1v+Ems/FF9q942pIN9xEHBjLHPyL6 IM4x3AFcp8S7m51L4ZeHbSRbi41SRba5nQRMW/1LhmOBgHca9XtNStL6xF7bSF4CCdxRlPHXggH9 KAPNfAdkmlfFzxFpkEsz29vbDyxLIXIyYz1P1NP0hE8Z/E3xBaeIw09vpR2WdhIx8oLux5hXoSQA cn+99MReF9Qtx8Y9dvm85ba/jWK2laBwsjfJxnHHQ9ai8VX2mWXxKvJvEVvqdkgtkTTrrTd0bTDG ZCzrhmIJAA6ADmgCvF4c0my+N8GkW9ks9ibcXHkF2K2kgBYFeeOVXg/3+lW/GMN3c/HPQYLKbyJ5 dNZBL3jU+eGYf7QXJHvitXwZ4k8AJq0lrpMksOp3jYeW+Dmac+hdyc544zye1Zmu6jbj446Pqf77 7HZWjwXEwgcqj4mGOnPLryOOaAKfj7w3Z+BpdG17QprqG/a9WKaWS4aQz5BJ3ZPPTGOhFXvjhY25 0/SbplYyverET5jY27W/hzgfXGak+M8y3Wn6TaW6SzTpeLO6RxM21NpGeB7/AFq18VYZfEHgey1D R7aS+W3vUuCEjYPsAdTwRnqRnigDs9H8OaT4f87+y7X7P5+3zP3jNu25x94n1NalYmgeJI/EW6S2 02/t7dUB866h8oMx/hAJySO5Ax71t0AFFFFAHzx46/5HbVf+vg/yrArf8df8jtqv/Xwf5CsCvXh8 KMHuepfBT/mNf9sP/aleqV5X8FP+Y1/2w/8AaleqV5+I/iM1hsFFFFYFENxcwWsRluJUiQcbnbA+ lOiljniWWKRZI3GVZDkEfWsDxTPKTZ21ipk1COT7VDHj5SEBzn6hiMDvVjw3e2s1hHBaM8gWISvI wAG52YkEdjkHj0xQBs46U1pokkjjeRFkkJCKWALYGTgd+KkrjPEd2rX8l9G0pk0l4zEqIxVucy5I GPukDn+7QB2VFVpp3fTXuLLZI7Ql4dxwrHGVz7Gsrw/qc19cSRT3EglijHm208QSRH7kYGCvpQBv daK5y+1W8tdaa3uJXtIXkjW2l8sNFIONys2MhjyB0q9rF7cQTWNnbMscl5Ns8xlzsUAk4HrxxQBq UtZNje3C65daXcSGYRwrNHKVAbaSQQ2BjqKri81TU7nUV0+4ig+xSiGJJF4kYYLFzgnGOBjFAG1N PDAgeeVIlLBQXYKCT0HPevNtCvNT8JeINan8SaLqd9Ld3BaDUrWA3C+Vn5U45QdMD/Cu08TzS2+l xzRmPK3EQZXjDggsB3Hv1qzrVzLa2BkhmhhdpFXfLngE84ABy2OgoA4fWtPvfiDr2kSQ6LdaZYab cCaW9vovKlkAIIRE+9g46nH6DPo/FY+g6hcXkt/BPI0otZgqSPF5bEFQeVwMdfQVB4fSY6rq7NdO yLdlTHtGD8q85xmgDoOlJgVz13qOqXOqahaaejg2UaBAojId2XcN24gheg4960NRn1GLRGntoAb0 IpMYwcHI3AepAzj1oA0qWsjQdQGoQzyC6eYLJt2yxBJI+BlXAA5z3rXoAKKKKAOL1b4X6JrGq3Go 3F1fpLcPvZY5ECg+2UJ/Wqn/AApzw9/z+an/AN/Y/wD4iiitFVmluTyo3vC/g3T/AAl9q+wTXMv2 rZv89lONu7GMKP7xroaKKhtt3ZQUUUUgKF9pNvfTw3LNLFcQZEcsT7WUHqPQj6imWGh2um3Ek9u0 waXmRWlJVm7sR6miigDQIyCMkZHUVTh0uKGxms1klZJmZnZmy3zfe5x7n86KKACHSreHSjpm6Rrc xmLDNyFIxjP0ottMitrprrfLNMyCPfK2SEBJwOPf6miigCObRLeeV2kkm8uWVZZIt/yOwxjI7dBw OuKsXthDfxokwbMbh43U4ZGHQg0UUAMs9NhspZZlLyTzY8yWVss2Og9h7CoZ9CtJruS53zxNMAJl ilKLLjpuA9vTFFFAE2oaZBqVstvMXWMMGxGccjkfqKW+02DUYI4rgyZikWRHVtrKw6EEd6KKAGWW kW+n3E08LTF58GTzJC249M89+KWDSre3vpruIyq87b3TzDsLYxnHTPFFFAEdzotvcXpvBLcQTOoW QwSlPMA6Bv8AHrVi50+C5tEtTvSNCpTy2KldvTBoooASz0+KyaZ1aSSWdt8skhBLHGB0wOnoKt0U UAf/2Q== --000000000000e47d5605fe8ece1b--