From: | Mahendra Singh <mahi6run(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema |
Date: | 2019-12-26 14:50:14 |
Message-ID: | CAKYtNAqq_XP32DTbaWuuOHZpE6HSKs3xOj_ONMWNoFzoJ7iCYQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On Thu, 26 Dec 2019 at 19:23, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Wed, Dec 25, 2019 at 12:24:10PM +0900, Michael Paquier wrote:
> > Arf. Yes, this had better be isAnyTempNamespace() so as we complain
> > about all of them.
>
> Okay, finally coming back to that. Attached is an updated patch with
> polished comments and the fixed logic.
Thanks Michael for patch.
Patch is fixing all the issues.
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=#
I have one doubt. Please give me your opinion on below doubt.
Let suppose, I connected 10 sessions at a time and created 1 temporary
table to each session. Then it is creating schema from pg_temp_3 to
pg_temp_12 (one schema for each temp table session). After that, I
closed all the 10 sessions but if I connect again any session and
checking all the schema, It is still showing pg_temp_3 to pg_temp_12.
Is this expected behavior ? or we should not display any temp table
schema after closing session. I thought that auto_vacuum wlll drop all
the temp table schema but it is not drooping.
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Zhihong Zhang | 2019-12-26 15:17:51 | Re: Indexing on JSONB field not working |
Previous Message | Michael Paquier | 2019-12-26 13:53:29 | Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2019-12-26 15:57:04 | Re: error context for vacuum to include block number |
Previous Message | Anastasia Lubennikova | 2019-12-26 14:45:19 | Re: standby recovery fails (tablespace related) (tentative patch and discussion) |