Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql

Keith Hickey <kwhickey@gmail.com> writes:
> Ok, that worked. Such a simple change.
> i.e. in the function definition, changed the return statement from
> return result::customer_tier;
> to
> return result::public.customer_tier;

Check.

> However --
> When running the restore as user "root", with the default search path
> (which was the case): "$user", public

pg_restore doesn't use the default search path anymore.

            regards, tom lane