Bruce Momjian wrote:
> I just added pg_stat_get_backend_mypid() that returns the pid. Does
> that help you?
Sorry for the slow response.
Backend pid doesn't solve this issue, because the temp schema name for a
logged-in user is based on MyBackendId, not pid, i.e. your temp schema
name is something like pg_temp_1 when MyBackendId = 1, etc. It would be
easy enough to write a function exposing this, the question is whether
it is desirable to expose it?
Joe