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 <calle.hedb...@gmail.com> > 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 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 >> running such sequential queries in one go? >> >> Regards >> Calle >> >> On Wed, 12 Aug 2020 at 22:53, Trung Do <chin.bi...@gmail.com> wrote: >> >>> 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 editor, somehow have part of the query selected but >>> that part is valid SQL, then run it and have no idea that it's not >>> running the whole thing. Being sneaky around something that deals with >>> data is IMO not a good thing. I think it's better if that's an opt-in >>> behavior instead. Just my 2c. >>> >>> >>> On Wed, 12 Aug 2020 at 15:36, richard coleman >>> <rcoleman.ascen...@gmail.com> wrote: >>> > >>> > 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, pgAdmin4 lacks the ability to "Run Selected" vs. "Run Entire >>> Query Window", so it implements the previously mentioned logic. >>> > >>> > So I guess what you should probably do is create a *feature* request >>> for this additional functionality. >>> > >>> > rik. >>> > >>> > On Wed, Aug 12, 2020 at 3:18 PM Trung Do <chin.bi...@gmail.com> wrote: >>> >> >>> >> 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) >>> >> >>> >> >>> >>> >>> >> >> -- >> >> *Carl-Anders (Calle) Hedberg* >> >> HISP >> >> Researcher & Technical Specialist >> >> Health Information Systems Programme – South Africa >> >> Cell: +47 41461011 (Norway) >> >> Iridium SatPhone: +8816-315-19119 (usually OFF) >> >> E-mail1: ca...@hisp.org >> >> E-mail2: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> > > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell: +47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg