From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br> |
Subject: | Help needed : temp tables. |
Date: | 2000-10-06 14:16:18 |
Message-ID: | 010d01c02f9f$fec988a0$98a0a8c0@dti.digitro.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-10-06 14:21:43 | Re: Using UnixODBC and postgresql |
Previous Message | bmccoy | 2000-10-06 14:15:54 | Re: adding data in one column |