Greg Stark <stark(at)mit(dot)edu> writes:
> While fixing up a patch I had dealing with temporary tables I noticed
> a bit of a quirk with pg_temp schemas. Namely that we have no actual
> meta data marking them as temporary aside from their names. And we
> don't do anything to protect that -- superuser can happily issue ALTER
> SCHEMA RENAME to rename it to a name that doesn't match pg_temp*.
This seems to me to be not very different from the 1001 other ways that
a superuser can break a database. If *non* superusers could rename
those schemas then I'd agree there's a problem to be solved.
regards, tom lane