From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Rod Taylor'" <rbt(at)barchord(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: User Log? |
Date: | 2002-01-14 08:14:58 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB1047413@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-01-14 08:31:07 | Re: [pgadmin-hackers] pgMigrate |
Previous Message | Dave Page | 2002-01-14 08:09:43 | Re: Highlight bug in 1.1.76-DEV |