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

Started by PG Bug reporting formover 7 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Noah Misch
noah@leadboat.com
In reply to: PG Bug reporting form (#1)
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
/messages/by-id/flat/20180405065957.GA2276534@rfd.leadboat.com. The exact
change depends on the definition of your object that references "earth".