Tom,> Those schemas seem to get more and more and more. Is anyprocess taking care
> of purging the ones no longer needed?We don't bother. One row in pg_namespace is not worth removing,especially when it's likely to be needed again someday.thanks for the information! Now I understand: every backend
"Harald Armin Massa" <[EMAIL PROTECTED]> writes:
> Now I looked at system objects and detected, that schemas named PG_TEMPn,
> where n is a slowly growing integer,
> are created.
> Those schemas seem to get more and more and more. Is anyprocess taking care
> of purging the ones no longer needed?
I create 2 temp tables on each connection to store session relevant variables.It works beautifully with code I robbed accross postgresql mailinglists:CREATE OR REPLACE FUNCTION set_quarant(mylvlquarant int4)
RETURNS int4 AS$BODY$ BEGIN perform relname from pg_class where relname