Discover temporary INDEX/TABLE name

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Discover temporary INDEX/TABLE name
Date: 2006-11-15 18:29:04
Message-ID: 455B5C70.000002.20703@pantene.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

How could I find out if a temporary table
(or index on a temporary table) was created
by current session?

The problem is something like
SELECT COUNT(*) FROM PG_INDEXES WHERE INDEXNAME='tmpind1'
does not work since temporary indexes from other sessions
are visible. I need a way to make a distinguish
between temporary things belong to current session
and others.

I really do appreciate any help.

--
Best regards
Ilja Golshtein

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toni Casueps 2006-11-15 18:33:40 sync linux and postgresql users and groups
Previous Message Ardian Xharra 2006-11-15 18:08:42 Re: Data corruption