On Saturday 17 February 2007 07:49, RPK wrote:
> PostgreSQL, already a mature database, needs to have more options for
> recovery as compared to proprietary databases. I just worked with Oracle's
> FlashBack query feature in Oracle 9i and FlashBack Table feature in 10g.
>
> Future versions of PostgreSQL must have similar features which enable users
> to bring Table(s) and/or Database(s) to a desired Time Stamp.

Advertising

Check out my proposal[1] for Temporal extensions. Ultimately, creating valid
time and transaction time tables would be possible through my proposal. Please
check it out.
[1]http://archives.postgresql.org/pgsql-hackers/2007-02/msg00540.php
wt
--
Warren Turkal (w00t)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match