> On Jul 20, 2020, at 02:28, Thorsten Schöning <tschoening@xxxxxxxxxx> wrote: > > Would be far easier if Postgres would do that automatically like it > seems to do for most other objects. The important point is that owning > those types seems to be per database, so things should be safe to do > automatically. I'm not sure I understand exactly how this "feature" would work. It seems to be "in the case that I am using CASTs that include internal types and restoring to a different, non-superuser user than the original one in the database that was dumped from, change the owner of internal types to make sure that my CAST restores work." That strikes me as a *very* ad hoc feature indeed. -- -- Christophe Pettus xof@xxxxxxxxxxxx
