Skip site navigation (1) Skip section navigation (2)

Re: procpid for temp schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ashok raj <ashokexplorer(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: procpid for temp schema
Date: 2009-03-31 14:07:38
Message-ID: 9042.1238508458@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
ashok raj <ashokexplorer(at)gmail(dot)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

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2009-03-31 14:11:55
Subject: Re: Hard link backup strategy
Previous:From: Emanuel Calvo FrancoDate: 2009-03-31 14:05:42
Subject: Re: PG Patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group