Le mardi 15 septembre 2009 à 06:54:59, Magnus Hagander a écrit :
> On 15 sep 2009, at 00.48, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
>
> wrote:
> > Le samedi 12 septembre 2009 à 14:49:04, Guillaume Lelarge a écrit :
> >> Le mercredi 9 septembre 2009 à 20:46:00, Roger Niederland a écrit :
> >>> First of all thanks for PGAdmin I've been using it for years now.
> >>>
> >> :)
> >>>
> >>> One small enhancement that would be very useful is:
> >>>
> >>> When viewing the Statistics tab for the server where the Current
> >>> Executing Queries is available (along with the current user,
> >>> database
> >>> etc..) It would be good to be able to copy the sql of a current
> >>> query.
> >>> I realize that it is impractical to show the full query sql (and
> >>> do not
> >>> want this). But I would like to be able to copy the "full sql" of
> >>> the
> >>> current query. I know that I can log long running queries, but
> >>> feel it
> >>> would be useful to copy the query from the statistics, so I can
> >>> paste it
> >>> into a query window for further analysis.
> >>
> >> It's already possible in 1.10, but it copies the whole line (not
> >> only the
> >> query). Anyways, that's one item on my todolist. We also want to be
> >> able to
> >> launch the query tool with this query (see
> >> http://code.pgadmin.org/trac/ticket/9). I hope all of these will be
> >> in
> >> 1.12.
> >
> > Here is a patch to lauch the query tool with the selected query. The
> > icon is
> > the copy one. Not great, but I don't really have design skills. I
> > wonder if we
> > can make the query tool icon smaller enough, so that it will fit in
> > the
> > toolbar. Anyways, with this patch, when you click on the toolbar
> > button, the
> > query tool opens a new connection on the selected database of the
> > same server,
> > displays the query and allows the user to modify/execute it.
> >
> > Comments?
>
> For long queries the whole string won't be available. Maybe we should
> try to detect that and issue an error?
>
Yeah, sure. This new version checks if the query size is at max size and
displays a message if it is. The contents of the message probably need some
work.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com