ashok raj <ashokexplorer@xxxxxxxxx> writes: > is there a way that we could find which procpid or connection that > has created a particular temporary schema (pg_temp_*) ?. In 8.3 and up, the number in the pg_temp_N schema name is the same as the first component of the virtualxids that that session uses. Not sure how much help that is to you, but if the session is actively doing anything you should be able to identify its number by watching pg_locks. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
