From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | PopeRigby <poperigby(at)mailbox(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Errors when restoring backup created by pg_dumpall |
Date: | 2024-12-11 05:22:01 |
Message-ID: | 2b1143ef-2740-437a-a68d-664bb36beca8@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/10/24 19:05, PopeRigby wrote:
> On 12/9/24 16:31, Adrian Klaver wrote:
>> On 12/9/24 15:30, PopeRigby wrote:
>>> On 12/9/24 15:23, Tom Lane wrote:
>>>> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>>>>> You could file an issue here:
>>>>> https://www.postgresql.org/account/login/?next=/account/submitbug/
>>>>> Ask if the developers could use the mechanisms available here:
>>>>> https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION
>>>> This wouldn't really move the needle, since (a) there is not some
>>>> magic group of people that will become involved who aren't already
>>>> and (b) the requested fix seems exactly the same as the work
>>>> already in progress at [1].
>>>>
>>>> What would help is to figure out why the proposed patch didn't
>>>> seem to work for you. I continue to suspect that you didn't
>>>> really install the updated extension, but it's unclear.
>>>>
>>>> regards, tom lane
>>>>
>>>> [1]
>>>> https://www.postgresql.org/message-id/flat/3395418(dot)1618352794(at)sss(dot)pgh(dot)pa(dot)us
>>>
>>> I compiled and installed PostgreSQL with the patch, and restarted it,
>>> so unless there are other steps I'm not sure what I could have done
>>> wrong.
>>>
>>
>>
>> What was the source of the patch?
>>
> This:
> https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch
>
If I am following correctly I believe you need this one:
It has the changes that include the schema qualifications. The one you
used does not have those modifications.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Bolaji Wahab | 2024-12-11 06:46:11 | Re: Clarification of behaviour when dropping partitions |
Previous Message | PopeRigby | 2024-12-11 03:05:53 | Re: Errors when restoring backup created by pg_dumpall |