Re: unlimited undo/journaling

On Wed, 2002-06-26 at 07:43, Carl Meyer wrote:

> hello,
>
> i wondered how an unlimited undo feature would be realized in
> postgresql.
>

I think Temporal SQL, which is perhaps a standard now, offers this
functionnality. Basically, it would allow you to create a table with
"transaction time" support and every modification would be stored
automatically with your data.
To get an idea of how simple it would be then to retrieve your data as
stored at a particular date, see the introduction to the (draft?) TSQL
standard :
ftp://ftp.cs.arizona.edu/tsql/tsql2/sql3/ansi-94-276.pdf

I think that the PostgreSQL developpers are very busy, so I wouldn't
expect this feature soon :-) Anyway, you have a dream now :-)

Cheers,

--
Arnaud Le Taillanter - alt(at)fr(dot)clara(dot)net
Claranet Système/Réseau