Re: absolute or relative updates - Mailing list pgsql-general

From A. Kretschmer
Subject Re: absolute or relative updates
Date
Msg-id 20051117060949.GA20828@webserv.wug-glas.de
Whole thread Raw
In response to absolute or relative updates  ("pgsql-general@list.coretech.ro" <pgsql-general@list.coretech.ro>)
List pgsql-general
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    ===

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wrong rows selected with view
Next
From: "Magnus Hagander"
Date:
Subject: Re: Does PG Support Unicode on Windows?