| From: | Mikko Partio <dun(at)haisuli(dot)net> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Cast record as text |
| Date: | 2007-02-17 12:39:15 |
| Message-ID: | 45D6F773.5070502@haisuli.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
A. Kretschmer wrote:
>> My original idea was to log changes from different tables to one audit
>> table, and I think tablelog uses separate audit tables for each monitored
>> table?
>>
>
> Yes, but with tablelog it is possible to restore any changes, you can
> restore a table.
>
> A blog-entry from Andreas Scherbaum, the maintainer, about tablelog:
> http://ads.wars-nicht.de/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
>
I agree that the ability to restore changes is quite nice, but my
primary goal is to record changes from many tables into one table, and I
think tablelog does not offer that. Do you know any way of casting a
record to text, or perhaps a different way altogether to audit to one
table? It's hard to believe I am the first person to come up to this
problem.
Regards
MP
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leonel Nunez | 2007-02-17 12:58:17 | Re: postgreSQL |
| Previous Message | Bob Hunter | 2007-02-17 11:12:44 | encoding problem at restore |