Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Feb 22, 2019 at 12:54 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> On Fri, Feb 22, 2019 at 3:43 AM Magnus Hagander <magnus@hagander.net> wrote:
>>>> We are certainly not supposed to go DROP SCHEMA on the temp namespaces, ...
>>> Actually, I think that's supposed to work.
>> If it's in active use by any session (including your own), that's not going
>> to have nice consequences; the owning session will have the OID in
>> static storage, and it will be unhappy when that OID becomes dangling.
> Maybe that's something we should fix?
Why? It would likely be a significant amount of effort and added overhead,
to accomplish no obviously-useful goal.
Note that all the temp schemas are made as owned by the bootstrap
superuser, so there is no real argument to be made that people might
be expecting they should be able to delete them.
regards, tom lane