absolute or relative updates
I want to write a trigger that logs any changes that are made to a row.
I have the old an new row values, but I am more interested in knowing if
the update was absolute "UPDATE table SET col = 3" or relative "UPDATE
table SET col = col + 2".
Is the a way (any way) to access this type of information ? In any
language available (C, PLPGSQL, etc.)
Thanks
Razvan Radu
am 16.11.2005, um 18:52:25 +0200 mailte pgsql-general@list.coretech.ro folgendes:
I want to write a trigger that logs any changes that are made to a row. I
You ivent the wheel the second time ;-)
http://pgfoundry.org/projects/tablelog/
have the old an new row values, but I am more interested in knowing if the
update was absolute "UPDATE table SET col = 3" or relative "UPDATE table
SET col = col + 2".
If you want restore a table and you have only relative log-entrys, the
you must restore all steps from start to this point.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===