| From: | "Ian Harding" <iharding(at)destinydata(dot)com> |
|---|---|
| To: | "Dan Black" <fireworker(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how can i view deleted records? |
| Date: | 2006-05-01 17:23:18 |
| Message-ID: | 725602300605011023l43d5b7f7v27018e1eb0041658@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-05-01 17:41:59 | Re: Is PostgreSQL an easy choice for a large CMS? |
| Previous Message | Wes | 2006-05-01 17:16:46 | Leading substrings - alternatives with 8.1.3? |