Re: View deleted records in a table - Mailing list pgsql-general

From Boyan Botev
Subject Re: View deleted records in a table
Date
Msg-id CACmxCsaAD87qJ+rQkAfh=VmnxQxtW2jRc_KfTTfBukANSob8yw@mail.gmail.com
Whole thread Raw
In response to Re: View deleted records in a table  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
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).



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: View deleted records in a table
Next
From: Boyan Botev
Date:
Subject: Re: View deleted records in a table