Hello *,
we started the use of temporary tables for evaluating data.
create temp table xxx ....
<evaluationcode>
drop temp table xxx;
We encountered some strange errors about relation exists or even does not
exist from server and application site. I started to look after orphan temp
tables. No orphans were left but I found namespace entries in pg_namespace.
select * from pg_namespace;
nspname | nspowner | nspacl
------------+----------+--------
pg_catalog | 1 | {=U}
pg_toast | 1 | {=}
public | 1 | {=UC}
pg_temp_1 | 1 |
pg_temp_8 | 1 |
pg_temp_11 | 1 |
pg_temp_10 | 1 |
pg_temp_6 | 1 |
pg_temp_4 | 1 |
pg_temp_3 | 1 |
pg_temp_14 | 1 |
pg_temp_2 | 1 |
pg_temp_5 | 1 |
pg_temp_12 | 1 |
(14 rows)
I did a vacuum full and analyze but this pg_temp namespaces are still there.
Any ideas about that phenomena ?
best regards
-Andreas Schmitz
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de