"Andreas 'ads' Scherbaum" <adsmail@xxxxxxxxxxxxx> writes: > 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. contrib/spi/timetravel might be worth looking at too. It hasn't been touched in awhile but AFAIK it still works. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
