While we are talking about this, is a development like Oracle "Flashback
queries" planned maybe?
You can "flashback" to old data, but you need to use the tablelog
functions.
Oracle Flashback Query seems to use undo logs to return in a point in time if the undo retention param permit it. You can do it with a date, or with the SCN (system change number), a kind of transaction number. It saves you administration task and table management, and
space.
Is this doable with PG, using some pg transaction logs?
More infos on oracle flashback nice feature:
http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm Bruno Lavoie