On Thu, 26 Dec 2019 at 23:21, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Mahendra Singh <mahi6...@gmail.com> writes: > > I think, we can add a regression test for this. > > postgres=# create temporary table temp(c1 int); > > CREATE TABLE > > postgres=# drop schema pg_temp_3 cascade ; > > ERROR: cannot drop temporary namespace "pg_temp_3" > > postgres=# > > No, we can't, because the particular temp namespace used by a given > session isn't stable. > > > I thought that auto_vacuum wlll drop all > > the temp table schema but it is not drooping. > > Generally speaking, once a particular pg_temp_N schema exists it's > never dropped, just recycled for use by subsequent sessions.
Okay. Understood. Thanks for clarification. Thanks and Regards Mahendra Singh Thalor EnterpriseDB: http://www.enterprisedb.com