Josh Berkus <josh@agliodbs.com> writes:
> Well, the first thing that comes to mind is that template0 should be
> "permanently frozen". That is, all objects in it should be created with
> frozen xid and mxids. After all, nobody can modify anything in it.
That sounds about as unsafe as can be. You can't stop superusers from
connecting to template0 and modifying it if they want to ... and I don't
really want to say "ok, the consequence of that is silent disaster many
moons later".
regards, tom lane