Re: [GENERAL] Cast record as text SOLVED

2007-02-17 Thread Mikko Partio
Mikko Partio wrote: 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

Re: [GENERAL] Cast record as text

2007-02-17 Thread Mikko Partio
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 Sch

Re: [GENERAL] Cast record as text

2007-02-14 Thread A. Kretschmer
am Wed, dem 14.02.2007, um 22:37:36 +0200 mailte Mikko Partio folgendes: > > Why do you want to reinvent the wheel? > > > > http://pgfoundry.org/projects/tablelog/ > > > > > > But it use a separate log-table per table. > > > > > > Andreas > > My original idea was to log changes from different tab

Re: [GENERAL] Cast record as text

2007-02-14 Thread Mikko Partio
> Why do you want to reinvent the wheel? > > http://pgfoundry.org/projects/tablelog/ > > > But it use a separate log-table per table. > > > Andreas 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

Re: [GENERAL] Cast record as text

2007-02-14 Thread A. Kretschmer
am Wed, dem 14.02.2007, um 16:38:27 +0200 mailte [EMAIL PROTECTED] folgendes: > Hi, > > I'm trying to build an audit system for several tables. My idea was to use > triggers and plpgsql to record changes made to "important tables" to a > special audit table. My problem is that I don't want to cre