I'm having problems with temporary tables in postgre.
I've been using Postgre 7.02 in a red hat 6.2 and I'm accessing using Delphi
5 + Winzeos Postgre Components. I've been using for some mounths and now I
checked that there are lots of temp tables in my system. These tables where
created by my application and I think everytime it crashed the temp tables
where not removed.
How can I delete a 'zombie' temp table? I tried to drop these tables, but
the following message appeared, per example :
relatorio=# \dS
List of relations
Name | Type | Owner
-------------------+---------+----------
...
pg_rules | view | postgres
pg_shadow | table | postgres
pg_statistic | table | postgres
pg_tables | view | postgres
pg_temp.10050.18 | table | postgres
pg_temp.10050.19 | table | postgres
pg_temp.10050.20 | table | postgres
pg_temp.10863.0 | table | postgres
pg_temp.10863.1 | table | postgres
pg_temp.10863.2 | table | postgres
pg_temp.10863.3 | table | postgres
pg_temp.10863.4 | table | postgres
pg_temp.10863.5 | table | postgres
pg_temp.10863.6 | table | postgres
...lots and lots more
relatorio=# drop table pg_temp.10863.1;
ERROR: parser: parse error at or near ".10863"
And if I try vacuum verbose analyze, I get this message:
NOTICE: --Relation pg_temp.10863.0--
NOTICE: mdopen: couldn't open pg_temp.10863.0: No such file or directory
ERROR: cannot open relation pg_temp.10863.0
Does someone know how to solve this problem?
Thanks!
José Vilson de Mello de Farias
Dígitro Tecnologia ltda - Brazil
