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

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(dot)bimbo(at)gmail(dot)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(dot)ascentgl(at)gmail(dot)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(dot)bimbo(at)gmail(dot)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: calle(at)hisp(dot)org

E-mail2: calle(dot)hedberg(at)gmail(dot)com

Skype: calle_hedberg