Discover temporary INDEX/TABLE name

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема Discover temporary INDEX/TABLE name
Дата
Msg-id 455B5C70.000002.20703@pantene.yandex.ru
обсуждение исходный текст
Ответы Re: Discover temporary INDEX/TABLE name
Re: Discover temporary INDEX/TABLE name
Список 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 по дате отправления: