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 |
