| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: absolute or relative updates |
| Date: | 2005-11-17 06:09:49 |
| Message-ID: | 20051117060949.GA20828@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am 16.11.2005, um 18:52:25 +0200 mailte pgsql-general(at)list(dot)coretech(dot)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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Kalchev | 2005-11-17 08:12:59 | Re: PG 8.1 on Dual XEON with FreeBSD 6.0 |
| Previous Message | Tom Lane | 2005-11-17 04:34:21 | Re: Wrong rows selected with view |