Help needed : temp tables.

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

Responses

Browse pgsql-general by date

  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