Re: Errors when restoring backup created by pg_dumpall
| От | Marco Torres |
|---|---|
| Тема | Re: Errors when restoring backup created by pg_dumpall |
| Дата | |
| Msg-id | CAG2LZV74_-Tsg2Msp1-SXyVT=QxA6BAijn0TskKo3N0QMN6xzg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Errors when restoring backup created by pg_dumpall (PopeRigby <poperigby@mailbox.org>) |
| Список | pgsql-general |
CREATE EXTENSION cube;
I do not know if you might need this one as well. I am assuming that you are working on a gist server.
CREATE EXTENSION earthdistance;I am assuming you are working with a gist server. This ought to be useful. https://gist.cs.berkeley.edu/pggist/
You might want to read this:
My advice is to go to google, then chat GPT if you do not get any good feedback here. Hopefully, this will give you good leads.
On Sat, Nov 30, 2024, 8:27 PM PopeRigby <poperigby@mailbox.org> wrote:
On 11/30/24 18:41, David G. Johnston wrote:On Saturday, November 30, 2024, PopeRigby <poperigby@mailbox.org> wrote:On 11/30/24 17:27, David G. Johnston wrote:On Saturday, November 30, 2024, PopeRigby <poperigby@mailbox.org> wrote:On 11/29/24 17:47, Adrian Klaver wrote:On 11/29/24 17:34, PopeRigby wrote:
psql:all.sql:4104: ERROR: type "earth" does not exist
LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
QUERY: SELECT cube(cube(cube(earth()*cos(radians($1))*cos(radians($2))),earth()*cos(radians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
CONTEXT: SQL function "ll_to_earth" during inlining
The earthdistance module is even getting added between the table with the earth type is added, so shouldn't there be no problem?The fact that “earth” is not schema qualified leads me to suspect you are getting bit by safe search_path environment rules.David J.Ah. How can I fix that?
Since you are past the point of fixing the source to produce valid dumps…that leaves finding the places in the text the lack the schema qualification and manually adding them in.David J.Oh boy. How can I prevent this from happening again?
В списке pgsql-general по дате отправления: