Re: User Log?

> -----Original Message-----
> From: Rod Taylor [mailto:rbt(at)barchord(dot)com]
> Sent: 12 January 2002 17:49
> To: pgadmin-support(at)postgresql(dot)org
> 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.