Re: Quirk of pg_temp schemas ...

2021-08-10 Thread Michael Paquier
On Tue, Aug 10, 2021 at 11:30:35AM -0400, Tom Lane wrote: > Greg Stark 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 >> d

Re: Quirk of pg_temp schemas ...

2021-08-10 Thread Tom Lane
Greg Stark 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

Quirk of pg_temp schemas ...

2021-08-10 Thread Greg Stark
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 renam