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

Great, thanks!
Regards
Calle

On Thu, 13 Aug 2020 at 06:08, Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)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(dot)hedberg(at)gmail(dot)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(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
>>
>
>
> --
> 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: calle(at)hisp(dot)org

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

Skype: calle_hedberg