From: | Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> |
---|---|
To: | Ankush Chawla <ankushchawla03(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: view the previous version of tables |
Date: | 2020-04-17 12:56:28 |
Message-ID: | CAE9k0Pm0eH8oCFBxBjL6tUDdfzXzx9UDpPv6GWL1bnNwX7exAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Please try installing pageinspect extension and re-run the queries. You amy
refer to the following URL for reference,
https://paquier.xyz/postgresql-2/postgres-contrib-module-highlight-pageinspect/
But, please note that you will only be able to see the deleted or updated
rows if they still exist in the page. If VACUUM has already cleaned those
then you won't be able to see it.
--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com
On Fri, Apr 17, 2020 at 6:14 PM Ankush Chawla <ankushchawla03(at)gmail(dot)com>
wrote:
>
> What is the command to view the previous version of rows (deleted or
> updated)
>
> I searched and found some functions like : . But none of them are working
> SELECT * FROM page_header(get_raw_page('school',0));
> SELECT * FROM heap_page_items(get_raw_page('school',0));
> ^
> Sorry for a basic question
> --
> Best Regards,
> Ankush Chawla
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Arnav | 2020-04-18 18:25:45 | VACUUM freeze |
Previous Message | Ankush Chawla | 2020-04-17 12:43:49 | view the previous version of tables |