am 16.11.2005, um 18:52:25 +0200 mailte pgsql-general@xxxxxxxxxxxxxxxx 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 === ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
