Re: Implementation of a updateable, "temporal" view on data

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Hans-Peter Oeri" <hp(at)oeri(dot)ch>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Implementation of a updateable, "temporal" view on data
Date: 2007-10-17 14:13:04
Message-ID: a55915760710170713l6692df23r2178d1536cb12d84@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 10/16/07, Hans-Peter Oeri <hp(at)oeri(dot)ch> wrote:
> Any help or link greatly appreciated

You could have main_table + audit_table, store all main_table changes
on audit_table using triggers, thus main_table always has the
"current" data. Then create the view on top of main_table.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oeschey, Lars (I/EK-142, extern) 2007-10-17 14:45:59 memory error
Previous Message Hans-Peter Oeri 2007-10-17 13:14:54 Re: Implementation of a updateable, "temporal" view on data