Postgres Pro
Downloads
Home   >   mailing lists

Forbid to DROP temp tables of other sessions - Mailing list pgsql-hackers

From Daniil Davydov
Subject Forbid to DROP temp tables of other sessions
Date
Msg-id CAJDiXgj72Axj0d4ojKdRWG_rnkfs4uWY414NL=15sCvh7-9rwg@mail.gmail.com
Whole thread Raw
Responses Re: Forbid to DROP temp tables of other sessions
Re: Forbid to DROP temp tables of other sessions
List pgsql-hackers
Tree view
Hi,
I noticed that TRUNCATE and ALTER commands on temporary tables of other sessions produce an error "cannot truncate/alter temporary tables of other sessions". But are there any reasons to allow us to DROP such tables?
It seems to me that the only case when we may need it is the removal of orphan tables. But the autovacuum is responsible for this and it uses a different functionality. I'm wondering if there are any other cases. If not, can we just handle it for example in ExecDropStmt and produce an error like "cannot drop temporary tables of other sessions"?

--
Best regards,
Daniil Davydov

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: proposal: schema variables
Next
From: Andrei Lepikhov
Date:
Subject: Re: cache lookup failed when \d t concurrent with DML change column data type