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). > > >
