Tom Lane wrote:
>
> It might be nice if manual changes to system objects got dumped,
> but that's really an AI-complete problem --- which properties of
> the objects represent manual changes, and how can we know whether
> trying to apply those changes to a new system version will work?
A diff against template0 or template1 could help, I guess.
Bug #3684 is related, though in this case the schema "public" may be
considered a preexisting *user* object.