Re: preserving data after updates

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: preserving data after updates
Date: 2005-03-05 13:05:14
Message-ID: 20050305140514.N658@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Its called a "temporal database".
> Usually its intended for medical or police databases where
> you need a hind sight. i.e. if today is 31/12/2005, what did we know at
> 20/12/2005.
> for example, for a doctor appearing at court and required to testify
> what he knew at 20/12/2005.
What he "can have known" not "what he knew".

With GnuMed we are running a trigger based auditing solution
which so far works nicely.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Meunier 2005-03-05 17:02:03 Cant migrate database from linux to win32 (pgsql 8.0)
Previous Message Martijn van Oosterhout 2005-03-05 12:25:49 Re: preserving data after updates