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

From Marcus Engene
Subject Re: Discover temporary INDEX/TABLE name
Date
Msg-id 455B7D82.4000608@engene.se
Whole thread Raw
In response to Discover temporary INDEX/TABLE name  ("Ilja Golshtein" <ilejn@yandex.ru>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Using SAN Splits to instantly copy a DB
Next
From: Niklas Johansson
Date:
Subject: Re: ORDER BY