Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Jerry Sievers <gsievers19@xxxxxxxxxxx> writes: > >> Yep thanks... but IMO something that simply exposes whatever internal >> registry of temp schemas/PIDs (which I presume must exist) > > Not really. There are a couple of ways that one could identify a > session's "BackendId", which is the "N" in the "pg_temp_N" name of > the temp schema that it would use if it uses one. But I do not think > there's any terribly reliable way to tell from outside the session > whether it has actually done anything with the temp schema. If it > hasn't, then at least in principle there could be objects in the > schema that are left over from a crashed session that previously had > the same BackendId. We only make an effort to clean out such objects > at the time that a session first creates a temp object. Hmmm, interesting. > In any case, I think you're right that this isn't exposed at the SQL > level presently. Roger that and what motivated the post was basically to explore that issue. Thx > > regards, tom lane > > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800
