Re: Discover temporary INDEX/TABLE name

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