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.
Andreas Schmitz [EMAIL PROTECTED] writes:
I did a vacuum full and analyze but this pg_temp namespaces are still there.
Any ideas about that phenomena ?
They're supposed to be there; we recycle the pg_namespace entry across
successive backend sessions. I see no point in deleting it only to
