On Tue, 10 Feb 2009 11:36:38 -0500 Bruno Lavoie wrote: > 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? I think, the only way is to use PITR and roll the backup forward during the exact point you want to see. Probably another way - but really untested and dangerous - would be to play around with the meta information for each row. But VACUUM makes sure dead rows are removed very fast, so i think it's not even worth to try out. Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
