From: Tom Lane <tgl@sss.pgh.pa.us>
To: ashok raj <ashokexplorer@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: procpid for temp schema
Date: Tue, 31 Mar 2009 10:07:38 -0400
Message-ID: <9042.1238508458@sss.pgh.pa.us> (raw)
In-Reply-To: <399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com>
References: <399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com>
ashok raj <ashokexplorer@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ashokexplorer@gmail.com
Subject: Re: procpid for temp schema
In-Reply-To: <9042.1238508458@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox