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

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

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

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

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

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

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