Re: Delete temp tables

: In short: if you want to delete a table there is one and only one
: safe method to do it: DROP TABLE.  The key difference between a temp
: table and a regular table is that the DROP will be done for you
: automatically when you disconnect.

Now why?
relatorio=#  DROP TABLE "pg_temp.1823.17";
ERROR:  class "pg_temp.1823.17" is a system catalog

I really need to erase these tables, because they are not been auto-removed
after my application crashes. I have more than 100 zombie temp tables in my
system. What are the system tables that I need to remove temp tables
information?

Regards,

José Vilson de Mello de Farias
Dígitro Tecnologia Ltda.

:
: regards, tom lane
: