Re: BUG #15326: keep getting "ERROR: type "earth" does not exist"while it does exist

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".