PITR and Temp Tables - Mailing list pgsql-general

From Huan Ruan
Subject PITR and Temp Tables
Date
Msg-id CAGgcTZtrBfPGXKwsPwK9JKNJWHs5c-a2HmNubsAi5gFUFEYqKQ@mail.gmail.com
Whole thread Raw
Responses RE: PITR and Temp Tables  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
Re: PITR and Temp Tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi All

Let's say at T0 a database has N session based temp tables. They would have corresponding records in the catalog tables like pg_class and pg_attribute that are visible to other sessions.

At T1, I do a PITR to T0. That recovered database should not have those temp tables because the sessions they were created in are not present. My question is what events trigger the deletion of those temp tables' catalog records (e.g. pg_class and pg_attribute etc.) in the recovered database?

Thanks
Huan

pgsql-general by date:

Previous
From: "Thomas, Richard"
Date:
Subject: RE: PostgreSQL 10.20 crashes / Antivirus
Next
From: Patrick FICHE
Date:
Subject: RE: PITR and Temp Tables