public inbox for [email protected]help / color / mirror / Atom feed
Saved SQL queries will not execute 5+ messages / 2 participants [nested] [flat]
* Saved SQL queries will not execute @ 2023-06-16 14:17 Sandy Haas <[email protected]> 2023-06-20 12:29 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Sandy Haas @ 2023-06-16 14:17 UTC (permalink / raw) To: pgadmin-hackers Good morning, I’m 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’m 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’ve scoured the web and the PGAdmin documentation, and the only thing I’ve 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 [email protected] 423-468-1634 (O) 423-413-7362 (C) [image: Celebrating-25-Years-w-Logo (2)] Attachments: [image/jpeg] image001.jpg (3.6K, 3-image001.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Saved SQL queries will not execute 2023-06-16 14:17 Saved SQL queries will not execute Sandy Haas <[email protected]> @ 2023-06-20 12:29 ` Aditya Toshniwal <[email protected]> 2023-06-21 13:52 ` RE: Saved SQL queries will not execute Sandy Haas <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Aditya Toshniwal @ 2023-06-20 12:29 UTC (permalink / raw) To: Sandy Haas <[email protected]>; +Cc: pgadmin-hackers 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 AM Sandy Haas <[email protected]> wrote: > Good morning, > > > > I’m 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’m 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’ve scoured the web and the PGAdmin documentation, and the only thing > I’ve 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 > > [email protected] > > 423-468-1634 (O) > > 423-413-7362 (C) > > [image: Celebrating-25-Years-w-Logo (2)] > > > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* <https://www.enterprisedb.com/; "Don't Complain about Heat, Plant a TREE" Attachments: [image/jpeg] image001.jpg (3.6K, 3-image001.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Saved SQL queries will not execute 2023-06-16 14:17 Saved SQL queries will not execute Sandy Haas <[email protected]> 2023-06-20 12:29 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> @ 2023-06-21 13:52 ` Sandy Haas <[email protected]> 2023-06-21 14:25 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Sandy Haas @ 2023-06-21 13:52 UTC (permalink / raw) To: Aditya Toshniwal <[email protected]>; +Cc: pgadmin-hackers Attached is the log file for the following example of what is happening. I open the query tool once I’m 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 <[email protected]> *Sent:* Tuesday, June 20, 2023 8:29 AM *To:* Sandy Haas <[email protected]> *Cc:* [email protected] *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 AM Sandy Haas <[email protected]> wrote: Good morning, I’m 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’m 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’ve scoured the web and the PGAdmin documentation, and the only thing I’ve 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 [email protected] 423-468-1634 (O) 423-413-7362 (C) [image: Celebrating-25-Years-w-Logo (2)] -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* <https://www.enterprisedb.com/; "Don't Complain about Heat, Plant a TREE" Attachments: [image/png] image001.png (31.9K, 3-image001.png) download | view image [image/png] image002.png (67.1K, 4-image002.png) download | view image [image/png] image003.png (92.1K, 5-image003.png) download | view image [image/png] image004.png (131.7K, 6-image004.png) download | view image [image/jpeg] image005.jpg (3.6K, 7-image005.jpg) download | view image [application/octet-stream] pgadmin4.1687354212969.log (10.5K, 8-pgadmin4.1687354212969.log) download ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Saved SQL queries will not execute 2023-06-16 14:17 Saved SQL queries will not execute Sandy Haas <[email protected]> 2023-06-20 12:29 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> 2023-06-21 13:52 ` RE: Saved SQL queries will not execute Sandy Haas <[email protected]> @ 2023-06-21 14:25 ` Aditya Toshniwal <[email protected]> 2023-08-04 22:39 ` RE: Saved SQL queries will not execute Sandy Haas <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Aditya Toshniwal @ 2023-06-21 14:25 UTC (permalink / raw) To: Sandy Haas <[email protected]>; +Cc: pgadmin-hackers 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 <[email protected]> wrote: > Attached is the log file for the following example of what is happening. > > > > I open the query tool once I’m 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 <[email protected]> > *Sent:* Tuesday, June 20, 2023 8:29 AM > *To:* Sandy Haas <[email protected]> > *Cc:* [email protected] > *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 AM Sandy Haas <[email protected]> wrote: > > Good morning, > > > > I’m 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’m 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’ve scoured the web and the PGAdmin documentation, and the only thing > I’ve 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 > > [email protected] > > 423-468-1634 (O) > > 423-413-7362 (C) > > [image: Celebrating-25-Years-w-Logo (2)] > > > > > > > -- > > Thanks, > > Aditya Toshniwal > > pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* > <https://www.enterprisedb.com/; > > "Don't Complain about Heat, Plant a TREE" > Attachments: [image/png] image001.png (31.9K, 3-image001.png) download | view image [image/png] image002.png (67.1K, 4-image002.png) download | view image [image/png] image003.png (92.1K, 5-image003.png) download | view image [image/png] image004.png (131.7K, 6-image004.png) download | view image [image/jpeg] image005.jpg (3.6K, 7-image005.jpg) download | view image ^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Saved SQL queries will not execute 2023-06-16 14:17 Saved SQL queries will not execute Sandy Haas <[email protected]> 2023-06-20 12:29 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> 2023-06-21 13:52 ` RE: Saved SQL queries will not execute Sandy Haas <[email protected]> 2023-06-21 14:25 ` Re: Saved SQL queries will not execute Aditya Toshniwal <[email protected]> @ 2023-08-04 22:39 ` Sandy Haas <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Sandy Haas @ 2023-08-04 22:39 UTC (permalink / raw) To: Aditya Toshniwal <[email protected]>; +Cc: pgadmin-hackers That seems to have fixed it. Thank you!!! thank you, ~sandy *From:* Aditya Toshniwal <[email protected]> *Sent:* Wednesday, June 21, 2023 10:26 AM *To:* Sandy Haas <[email protected]> *Cc:* pgadmin-hackers <[email protected]> *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 <[email protected]> wrote: Attached is the log file for the following example of what is happening. I open the query tool once I’m 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 <[email protected]> *Sent:* Tuesday, June 20, 2023 8:29 AM *To:* Sandy Haas <[email protected]> *Cc:* [email protected] *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 AM Sandy Haas <[email protected]> wrote: Good morning, I’m 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’m 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’ve scoured the web and the PGAdmin documentation, and the only thing I’ve 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 [email protected] 423-468-1634 (O) 423-413-7362 (C) [image: Celebrating-25-Years-w-Logo (2)] -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* <https://www.enterprisedb.com/; "Don't Complain about Heat, Plant a TREE" ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-08-04 22:39 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-06-16 14:17 Saved SQL queries will not execute Sandy Haas <[email protected]> 2023-06-20 12:29 ` Aditya Toshniwal <[email protected]> 2023-06-21 13:52 ` Sandy Haas <[email protected]> 2023-06-21 14:25 ` Aditya Toshniwal <[email protected]> 2023-08-04 22:39 ` Sandy Haas <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox