| From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br> |
| Subject: | Re: Delete temp tables |
| Date: | 2000-10-25 10:50:47 |
| Message-ID: | 002b01c03e71$6efa5520$98a0a8c0@dti.digitro.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
: 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
:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DaVinci | 2000-10-25 11:17:58 | Can I deactivate indexes? |
| Previous Message | Vince Vielhaber | 2000-10-25 10:26:57 | Re: three things |