Keith Hickey <kwhickey(at)gmail(dot)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