Re: temporal support patch - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: temporal support patch
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207E6A6F9@exadv11.host.magwien.gv.at
Whole thread Raw
In response to temporal support patch  (Miroslav Šimulčík <simulcik.miro@gmail.com>)
Responses Re: temporal support patch
List pgsql-hackers
Miroslav Šimulcík wrote:
> as a part of my master's thesis I have created temporal support patch for PostgreSQL. It enables the
> creation of special temporal tables with entries versioning. Modifying operations (UPDATE, DELETE,
> TRUNCATE) on these tables don't cause permanent changes to entries, but create new versions of them.
> Thus user can easily get to the past states of the table.

Most of that is something you could handle with triggers (not TRUNCATE of course).

What does your proposed feature do that a set of triggers wouldn't?

Yours,
Laurenz Albe

pgsql-hackers by date:

Previous
From: Miroslav Šimulčík
Date:
Subject: Re: temporal support patch
Next
From: Miroslav Šimulčík
Date:
Subject: Re: temporal support patch