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@xxxxxxxxx> 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
