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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
