Re: User Log?

[Dave Page]

> -----Original Message-----
> From: Rod Taylor [mailto:[EMAIL PROTECTED]] 
> Sent: 12 January 2002 17:49
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] User Log?
> 
> 
> I'd first like to thank you for no longer creating the 'SPAM' 
> pga_* tables.  This allows me to actually use the tool on 
> real systems rather than just the toy ones.

pga_* tables aren't pgAdmin's - someone else complained to me about them,
but all pgAdmin stuff is pgadmin_*. That aside, you realise there is an
option on the Advanced menu in pgAdmin to remove them all?

> An operation I do on a regular basis is run some queries 
> against a development database (my muck about one).  Then I 
> run them against the programmers database.  Let the 
> programmers regress their code to ensure it functions as 
> expected.  Then I run the exact same queries against the test 
> database where the QA staff can confirm the fix and continued 
> operation.  Later I run them against the live database.
> 
> If pgAdmin could record an editable playlog of all actions I 
> do to the system (comments, structure changes, function 
> changes, and hand
> queries) that would be excellent.  This playlog should not 
> include any of PGAdmins internal dataselects.  Since there 
> may be several days between steps the user should be able to 
> record the log with a description.  A replay function will 
> allow the user to 'play the log' against another database as 
> requested.  Editing can be strictly removing some 'mistaken 
> steps'.  Ideally I should be able to do a test play (rollback 
> at the end rather than commit) to confirm it can be applied 
> after editing.

There was a function in pgAdmin I that did something like this - nobody
really used it though except my team at work to my knowledge. Anyway, I'll
add it to the To-Do list as that seems like a good idea in the different
format that you describe.

Regards, Dave.