Help needed : temp tables.
От | Vilson farias |
---|---|
Тема | Help needed : temp tables. |
Дата | |
Msg-id | 010d01c02f9f$fec988a0$98a0a8c0@dti.digitro.com.br обсуждение исходный текст |
Ответы |
Re: Help needed : temp tables.
|
Список | 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
В списке pgsql-general по дате отправления: