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 1qAEBv-0001zz-9b for pgadmin-hackers@arkaria.postgresql.org; Fri, 16 Jun 2023 18:28:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qAEBu-0005J0-6D for pgadmin-hackers@arkaria.postgresql.org; Fri, 16 Jun 2023 18:28:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qAAH2-000685-VC for pgadmin-hackers@lists.postgresql.org; Fri, 16 Jun 2023 14:18:01 +0000 Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qAAH0-002Xhc-4C for pgadmin-hackers@postgresql.org; Fri, 16 Jun 2023 14:17:59 +0000 Received: by mail-lj1-x232.google.com with SMTP id 38308e7fff4ca-2b448b24a61so10279931fa.1 for ; Fri, 16 Jun 2023 07:17:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mccright-com.20221208.gappssmtp.com; s=20221208; t=1686925075; x=1689517075; h=to:subject:message-id:date:thread-index:mime-version:from:from:to :cc:subject:date:message-id:reply-to; bh=2gXvJhy38LdrO1wfLa9g2SrQLWnLVrMlJ7KYqmVoRYc=; b=WCG7kplp1Gji0prYlpsFh8h6ppnvAmyreudGixNDGDHGaSGyJ/C+eDZVDtxmZTyhhV DlUIfF7/+r3ii2l4hOAh2ZsjtdyDjz5Jlxr5jPbCfd+29oiOkVz1Ew3VCw+N2UiIM4a9 e8beDKahMF0fY/pf4Uug6o/KpDH7kezrWm9lEJRcceNGwJ09SLttZ/d90dEKNN92kznB l1tF+UnqoSQpQ8Axn0b+bFSXKYjeNbhsgH07uOfZymRZf2g/PEsLG+3f4QYIM1bHnCGQ l1/VAushvf3qFGyjTnimcp+l+Gmbr5+JYdV3g4AOaWqI+w8/NvZlC/BFKNlRje3GJiK4 mcfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686925075; x=1689517075; h=to:subject:message-id:date:thread-index:mime-version:from :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=2gXvJhy38LdrO1wfLa9g2SrQLWnLVrMlJ7KYqmVoRYc=; b=OBp6sl4rhdfSP+AbiX3p5kNkvKUAWnKYaHjONtspRqB/4QpecX0Dzk8mGG9cPGq2zI mFeDjuqCjazTsPVSvLaIeWkrrPVlyOBV94egiSkliwVmZi5q2sqhV57g/E7ahebJbth7 +ECFbQu3Hagao+f7v2Rs0aYuXU/NgTQkYIPsZ42xzBpw+mktypkl+ySJSswKZ7lwLk8A PbU57YjYIaaakwT/Sd0pamuwc9CJJUJEpe0bBeyr8f4qd2D8AESlHa+iae8sZatmcJbn 5ApV6QhrCC8tSrTHOWc0HLIvWQN1AYcOPBXZTLNDjyEMs+OwjurIyQLOEq7qLeg7slGX nCSg== X-Gm-Message-State: AC+VfDyHOvjT5TVKTvh7/51nt8g409l5ShyXARz2RISLsJNa4ydG2s15 SR9Fv0eitOLpG39qfdV91iD1AoZYAe1CSJDvKBCjyEzHp+Rc90c8 X-Google-Smtp-Source: ACHHUZ6SW4tJ2eZpH1LHMLSlkHXlgotSMeeI91KWWwJUx+kET8w0744S5+wlt2//Plr09MffvZs9fCXHWidv+wCMF3g= X-Received: by 2002:a2e:80c9:0:b0:2b3:2f9b:7c9d with SMTP id r9-20020a2e80c9000000b002b32f9b7c9dmr1854322ljg.28.1686925074995; Fri, 16 Jun 2023 07:17:54 -0700 (PDT) From: Sandy Haas MIME-Version: 1.0 X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdmgWLZCG/sFFj2rSPy2uJmq51TfRg== Date: Fri, 16 Jun 2023 10:17:52 -0400 Message-ID: <5201fc200379e3e6192139b2bf561491@mail.gmail.com> Subject: Saved SQL queries will not execute To: pgadmin-hackers@postgresql.org Content-Type: multipart/related; boundary="000000000000dbc98205fe3fd948" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dbc98205fe3fd948 Content-Type: multipart/alternative; boundary="000000000000dbc98105fe3fd947" --000000000000dbc98105fe3fd947 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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)] --000000000000dbc98105fe3fd947 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Good morning,

=C2=A0

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

=C2=A0

Wh= en 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 quer= y 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 sc= oured the web and the PGAdmin documentation, and the only thing I=E2=80=99v= e found referencing issues, is to check that auto commit is on, and it is.<= /span>

=C2=A0

I did 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 appreciated.

=C2=A0

=C2=A0

=C2=A0

Sincerely,

=C2=A0

Sandy Haas

Logistics/Data Managem= ent

Special Projects

sand= yh@mccright.com

423-468-1634 (O)

4= 23-413-7362 (C)

3D"Celebrati=

=C2=A0

<= /body> --000000000000dbc98105fe3fd947-- --000000000000dbc98205fe3fd948 Content-Type: image/jpeg; name="image001.jpg" Content-Disposition: inline; filename="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: 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== --000000000000dbc98205fe3fd948--