On Apr 25, 2007, at 7:01 PM, Simon Riggs wrote:
>> (this is for a DELETE FROM table without any WHERE clause). I see
>> the XID, but can you also display date and time in the ouput ?
> Original date/time is available only on COMMIT/ABORT records, so
> need to search ahead/behind.
Additionally, you can specify an XID when doing a point-in-time
restore; you don't need to find an exact time to restore to.
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
pgsql-admin by date
|Next:||From: Rajesh Kumar Mallah||Date: 2007-04-29 17:05:11|
|Subject: Re: question about installing perl module|
|Previous:||From: Jonah H. Harris||Date: 2007-04-27 13:35:26|
|Subject: Re: PostgreSQL8.2.3 Performance|