Discover temporary INDEX/TABLE name - Mailing list pgsql-general

From Ilja Golshtein
Subject Discover temporary INDEX/TABLE name
Date
Msg-id 455B5C70.000002.20703@pantene.yandex.ru
Whole thread Raw
Responses Re: Discover temporary INDEX/TABLE name
Re: Discover temporary INDEX/TABLE name
List 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

pgsql-general by date:

Previous
From: "Ardian Xharra"
Date:
Subject: Re: Data corruption
Next
From: "Toni Casueps"
Date:
Subject: sync linux and postgresql users and groups