Feature Request: query history

[John Huss-2]

I would like to have the ability the view and edit and run any query that has already been executed in the Query screen.  Ideally this would keep track of queries persistently and not just for the current session.

Lots of other DB management software has this; for example, Interbase 7.1+ (IBConsole) and Frontbase (Frontbase Manager) are two I have used that do this.

The "Favorites" feature is kind of like this, but it meets a different need. 

[Magnus Hagander-2]

> I would like to have the ability the view and edit and run any query that
> has already been executed in the Query screen.  Ideally this would keep
> track of queries persistently and not just for the current session.

Are you describing something likevthe "history" feature in a browser?

If so, I have a half done patch around somewhere that could maybe be dusted off...

/Magnus

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Wed, Sep 10, 2008 at 2:15 PM, Magnus Hagander <magnus@...> wrote:
>
>> I would like to have the ability the view and edit and run any query that
>> has already been executed in the Query screen.  Ideally this would keep
>> track of queries persistently and not just for the current session.
>
> Are you describing something likevthe "history" feature in a browser?
>
> If so, I have a half done patch around somewhere that could maybe be dusted off...

Iirc, the DB2 query tool (circa 2004) had a combo box at the top of
the editor to which it added every query you ran in a session. Select
an entry, and it replaced the current query.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Magnus Hagander-2]

Dave Page wrote:

> On Wed, Sep 10, 2008 at 2:15 PM, Magnus Hagander <magnus@...> wrote:
>>> I would like to have the ability the view and edit and run any query that
>>> has already been executed in the Query screen.  Ideally this would keep
>>> track of queries persistently and not just for the current session.
>> Are you describing something likevthe "history" feature in a browser?
>>
>> If so, I have a half done patch around somewhere that could maybe be dusted off...
>
> Iirc, the DB2 query tool (circa 2004) had a combo box at the top of
> the editor to which it added every query you ran in a session. Select
> an entry, and it replaced the current query.

My half-patch had a menu, kind of like the history menu in firefox (or
whatever browser - I'm sure they all have it). But the same principle.

//Magus


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[John Huss-2]

Yeah, that sounds good.  It would be great if it stored the history across sessions too so if you close the app you can still get to the previous queries later.

John

My half-patch had a menu, kind of like the history menu in firefox (or

whatever browser - I'm sure they all have it). But the same principle.

[Andreas Neumann-7]

soundy good - I'd like such a feature as well. We'll have to limit it to a
maximum number of queries, though (50,100,200?) so the history doesn't
grow infinitely.

Andreas

> Yeah, that sounds good.  It would be great if it stored the history across
> sessions too so if you close the app you can still get to the previous
> queries later.
>
> John
>
> My half-patch had a menu, kind of like the history menu in firefox (or
>> whatever browser - I'm sure they all have it). But the same principle.
>>
>

--
Andreas Neumann
Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
Email: a.neumann@..., Web:
* http://www.carto.net/ (Carto and SVG resources)
* http://www.carto.net/neumann/ (personal page)
* http://www.svgopen.org/ (SVG Open Conference)
* http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support