Re: Results messages in "results output" window

2015-02-13 19:09 GMT+01:00 J.F. Oster <jinfroster(at)mail(dot)ru>:

> Hello Edson,
>
> Friday, February 13, 2015, 8:54:58 PM, you wrote:
>
> ER> On 13-02-2015 15:46, Guillaume Lelarge wrote:
>
> ER> Le 13 fevr. 2015 18:39, "Edson Richter"
> ER> <edsonrichter(at)hotmail(dot)com> a ecrit :
> >>
> >> Dear friends,
> >>
> >> I've been using PgAdmin 12.0.0 released on Jan 6, 2015,
> >> compiled in my Ubuntu 14.04 x64.
> >> Nothing noticiable in terms of use (actually, there are few
> >> known bugs, but they don't bug me anyway).
> >>
> >> I would like to know if there is any change to enable
> >> processing results to appear in Results output window when
> >> running a script the this one:
> >>
> >> begin transaction;
> >> update mytable set factor_xy = 10 where factor_xy = 15 and
> nature_id = 4;
> >> commit transaction;
> >>
> >> Today I get the following output:
> >>
> >> [QUERY═══ ] begin transaction
> >> [QUERY═══ ] update mytable set factor_xy = 10 where
> >> factor_xy = 15 and nature_id = 4
> >> [QUERY═══ ] rollback transaction
> >>
> >> I would like to get something like:
> >>
> >> [QUERY═══ ] begin transaction
> >> 0 rows changed.
> >> [QUERY═══ ] update mytable set factor_xy = 10 where
> >> factor_xy = 15 and nature_id = 4
> >> 16 rows changed.
> >> [QUERY═══ ] rollback transaction
> >> 0 rows changed.
> >>
> >>
> >> Is there any configuration I can change to get this?
> >>
>
>
> ER> Nope. There's nothing for this.
>
>
> ER> Ok, I see. So, results window is almost useless when running
> scripts...
> ER> Any tip on where to look if I can provide a patch for this?
>
> Hi! As far as I know, pgAdmin sends the whole query text to Postgres
> "as-is". Then, Postgres parses it and executes as a series of queries,
> returning output related to the last one. So, first of all pgAdmin
> should split the text into separate queries and perform them serially.
> Then it can append results to the output window (and probably
> render several result grids in a tabbed manner - cool!).
>
>
Well, I have looked into the several result grids, and AFAIR, you don't
need to split the queries to make it work. The main issue for this feature
is a UI issue. (And then a time issue, as you need time to work on this.)

> How to parse query text and split it into separate queries? I hope
> that code related to pgScript feature will help.
>
>
Correct, but don't hold your breath.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com