Thread: Bug #868: temp schema can't be clean automatically

trainee (trainee12@yeah.net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
temp schema can't be clean automatically

Long Description
postgresql 7.31  + mandrake linux 8.1

when I create a temporary table, server will  create temporary schema pg_temp_X automatically.
after I disconnect the server, the temporary table will be drop automatically, but temporary schema can't be drop
automatically.
So my database remain several temporary schema, I don't know why?

Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> So my database remain several temporary schema, I don't know why?

Because it's designed to work that way.  What's the point of dropping
the schema entry, only to have to recreate it later?

            regards, tom lane