Re: [GENERAL] tablelog

2009-02-11 Thread Dimitri Fontaine
Hi, On Tuesday 10 February 2009 17:36:38 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 admin

Re: [GENERAL] tablelog

2009-02-10 Thread Tom Lane
"Andreas 'ads' Scherbaum" 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 trans

Re: [GENERAL] tablelog

2009-02-10 Thread Andreas 'ads' Scherbaum
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 administ

Re: [GENERAL] tablelog

2009-02-10 Thread Bruno Lavoie
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 i

Re: [GENERAL] tablelog

2009-02-10 Thread Andreas 'ads' Scherbaum
Hello Philippe, i'm the author of tablelog. On Tue, 10 Feb 2009 11:52:13 +0100 Philippe Lang wrote: > I'm using tablelog (http://pgfoundry.org/projects/tablelog/) on an old > FreeBSD 6 / Postgresql 7.4 server, and I'm really happy with it. It > always worked great. > > I saw this morning tha

[GENERAL] tablelog

2009-02-10 Thread Philippe Lang
Hi, I'm using tablelog (http://pgfoundry.org/projects/tablelog/) on an old FreeBSD 6 / Postgresql 7.4 server, and I'm really happy with it. It always worked great. I saw this morning that the project used to be accepted for a while in the debian packages repository, but has been removed last yea