On Tue, Aug 14, 2018 at 10:16:30PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15326
> Logged by: Yujing Zhou
> Email address: yujing@amne.co
> PostgreSQL version: 10.5
> Operating system: Mac OS
> Description:
>
> The issue is that when I tried to restore the archive to my local database,
> it keep saying "ERROR: type "earth" does not exist" while it does exist in
> my public schema(I checked it in DataCrip). I have no idea what is going on
> and which part is wrong, feeling really weird. I hope you can help figure
> out the problem.
You need a change similar to the CREATE OR REPLACE FUNCTION in
https://postgr.es/m/flat/20180405065957.GA2276534@rfd.leadboat.com. The exact
change depends on the definition of your object that references "earth".