Re: Cannot use a standalone backend to VACUUM in "postgres"" - Mailing list pgsql-general

Alvaro Herrera <alvherre@commandprompt.com> writes:

> Hmm, nope -- take away the relnamespace check, because there is a
> different namespace for each backend (pg_temp_2, pg_temp_3, etc).

Still no luck, changed the query to:

  select relname, age(relfrozenxid) from pg_class join pg_namespace n on (n.oid = relnamespace) where nspname ~
'^pg_temp'

and no temp tables showed in any database :-(. Any other idea?.

Regards,
Manuel.