Re: Discover temporary INDEX/TABLE name

Поиск
Список
Период
Сортировка
От Marcus Engene
Тема Re: Discover temporary INDEX/TABLE name
Дата
Msg-id 455B7D82.4000608@engene.se
обсуждение исходный текст
Ответ на Discover temporary INDEX/TABLE name  ("Ilja Golshtein" <ilejn@yandex.ru>)
Список pgsql-general
Ilja Golshtein skrev:
> 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.
>


Hi,

Would it be terrible stupid of me to suggest you name
the temporary things with f.ex pg_backend_pid() appended
to the name? Or is the naming outside of your control?

Best regards,
Marcis

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Using SAN Splits to instantly copy a DB
Следующее
От: Niklas Johansson
Дата:
Сообщение: Re: ORDER BY