That works only if I know I will need the deleted/updated records for a table ahead of time. I need this feature/ability as a way to perform "data forensics" on a random table that someone has done something to. Next time it may be another table. Basically I need a way to remove the visibility map and show all records along with xmin and xmax alongside so I can tell what records were there and what exactly happened.
>I want to view deleted records in table from a week ago i
The accepted method for handling deleted (or updated) records is to create a TRIGGER (or RULE) on the table(s) that writes the record to a history file after it has been deleted (or updated).
