Le 19/11/2009 21:35, Guillaume Lelarge a écrit : > Le jeudi 19 novembre 2009 à 00:57:55, Dave Page a écrit : >> On Wed, Nov 18, 2009 at 8:55 PM, Guillaume Lelarge >> >> <guilla...@lelarge.info> wrote: >>> Le lundi 16 novembre 2009 à 19:08:29, Little, Douglas a écrit : >>>> Hi, >>>> I'm new to this community and not sure how to submit feature request. >>>> Please advise. >>>> >>>> I'm converting from Teradata to greenplum, and one nice feature in our >>>> TD query tool was a query history. Timestamp, completion code, rows >>>> affected, and sql statement >>>> >>>> PGadmin seems to be very unstable in our environment, and is crashing >>>> all the time. A query history would be real helpful. Thanks >>> >>> There is already a query history. But we don't record it. It would >>> probably be interesting to do it. We need to know more about what you >>> would like to have this. In which file should we record this? how someone >>> can work with this history file? etc. >> >> It's been on my mental todo list for a while (but feel free to give it >> a go). There is/was a similar in the DB2 management GUI which I used a >> little a few years back - basically, they have a combo box above the >> query input STC (spanning the width of the STC), in which every time >> you execute a query, it adds a flattened (ie. \n's replaced with >> spaces, double spaces replaced with single) version of the first few >> lines to the combo list. If you select one of those queries, it simply >> replaces the STC contents with the unflattened version of the original >> query. >> > > I recorded that as ticket # 93 (http://code.pgadmin.org/trac/ticket/93). > >
OK, I have something like this working. See the screenshot to have a look at it. Actually, it loads the file at startup. If you choose an item, it puts the query in the query text box. If you execute a query, it adds the query in the combobox and save the contents of the combobox. When writing the code, I had four questions: * should we have a global history or a history per database? I prefer the former... * probably I need to add a Clear button? * should I add options to allow the change the filename? * is there anything else I have to add? Comments? -- Guillaume. http://www.postgresqlfr.org http://dalibo.com
<<attachment: histoquery1.png>>
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
