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

From: Noah Misch <noah(at)leadboat(dot)com>
To: yujing(at)amne(dot)co, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15326: keep getting "ERROR: type "earth" does not exist" while it does exist
Date: 2018-11-12 07:23:33
Message-ID: 20181112072333.GA1072831@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)amne(dot)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(dot)GA2276534(at)rfd(dot)leadboat(dot)com(dot) The exact
change depends on the definition of your object that references "earth".

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Frank Büttner 2018-11-12 09:14:56 Re: BUG #15493: Wrong name of fields/missing fields for the internal statistic
Previous Message PG Bug reporting form 2018-11-12 07:15:35 BUG #15497: An error occurred initializing the application server: Failed to launch application server