Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Calle Hedberg
Great, thanks! Regards Calle On Thu, 13 Aug 2020 at 06:08, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Calle, > > The feature is not implemented yet - > https://redmine.postgresql.org/issues/3256. > > On Thu, Aug 13, 2020 at 4:59 AM Calle Hedberg > wrote: > >> Hi >> >> I fi

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Aditya Toshniwal
Hi Calle, The feature is not implemented yet - https://redmine.postgresql.org/issues/3256. On Thu, Aug 13, 2020 at 4:59 AM Calle Hedberg wrote: > Hi > > I find that a nice feature... But if I may ask a related question that > baffles me: If I paste multiple queries into a window and then run a

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Calle Hedberg
Hi I find that a nice feature... But if I may ask a related question that baffles me: If I paste multiple queries into a window and then run all of them, they all run BUT the output window only show the last sub-query result. Is there a configuration setting that will concatenate output when run

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Trung Do
I see, thanks for the explanation. It's a strange feature then, since I accidentally selected part of the query and was so puzzled at the cryptic error message that followed. And having an error is actually the best case scenario. I can see someone doing copy/paste operations to/from this query edi

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread richard coleman
Jack, It's fine as it is once you get used to it. For more involved or complicated queries I use another tool that gives me the option to either: "Run Script", which runs the entire query window "Run Statement", which has the benefit of running the selected text OR (and this is the part I really

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Jack Royal-Gordon
I don’t know if it’s even a good idea to change that functionality. When I’m working on performance issues, I very well may put a very complicated SQL statement with several sub-selects in the window, and start with just one of the sub-selects to see what it’s performance issues might be. So it’

Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread richard coleman
That's not a bug, it's a *feature* !! Seriously though, presently the query window in pgAdmin4 has two options: If nothing is selected -> run the entire window If something is selected -> run just what's selected. That's how it's been since, well as long as I can recall. Unlike some other tools,

Bug report: pgAdmin takes selected portion of query in Query Editor to run

2020-08-12 Thread Trung Do
If I enter a well formed SQL query into the Query Editor, but only select a portion of the query with the mouse and try to run, pgAdmin will try to run the selected portion as the query (and will fail most of the time because of syntax error)