There used to be a knob that would allow you to temporarily see
deleted tuples. Don't know if it's still there. Sounded kinda
dangerous.
http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
Also, you could start (now) using PITR so you could simply restore to
the moment before the records you are interested in were deleted.
Good luck,
- Ian
On 4/29/06, Dan Black <fireworker@gmail.com> wrote:
> Hello, everybody!
> How can I view deleted records in table?
>
> --
> Verba volent, scripta manent
> Dan Black
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>