Magnus Hagander <magnus@hagander.net> writes: > I think we're better off just peventing the explicit drop of a temp schema. > See attached?
I think this is a poor implementation of a bad idea. Would you like a list of the ways a superuser can break the system? We could start with "DELETE FROM pg_proc;".
Yeah, true.
That said, I'm not sure there is much point in fixing the original problem either. It comes down to a "don't do that", as the system just keeps crashing even if we fix that one. Trying to fix every possible place that breaks if there are tables with invalid data in pg_class like that is not likely to work either.