Manuel Sugawara wrote: > Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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?. None :-( Is there any table with a large age value, regardless of temp-ness? Does the age of the oldest table correspond to the age of pg_database.datfrozenxid? The interesting database is the one with the largest age(pg_database.datfrozenxid). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
