Thread: BUG #15326: keep getting "ERROR: type "earth" does not exist" whileit does exist

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.

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