Re: BUG #16460: Error when executing REFRESH MATERIALIZED VIEW WITH DATA;

Hi,

This should be fixed in the recent updates (with -2 build number) that were
out.

On Mon, Jun 15, 2020 at 12:56 PM Sandeep Thakkar <
sandeep(dot)thakkar(at)enterprisedb(dot)com> wrote:

> Thanks for reporting. This looks like the install name issue. Will fix it
> and provide an updated installer.
>
> On Mon, May 25, 2020 at 10:21 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16460
>> Logged by: Randall Williams
>> Email address: randall(dot)williams(at)analyteks(dot)com
>> PostgreSQL version: 12.3
>> Operating system: macOS 10.14.6
>> Description:
>>
>> Here is the error message:
>>
>> ERROR: could not load library
>> "/Library/PostgreSQL/lib/postgresql/llvmjit.so":
>> dlopen(/Library/PostgreSQL/lib/postgresql/llvmjit.so, 10):
>> Library not loaded: @loader_path/../..//opt/local/lib/libncurses.6.dylib
>> Referenced from: /Library/PostgreSQL/lib/postgresql/llvmjit.so
>> Reason: image not found
>>
>> When the error occurs, I am running as a non-administrative user in macOS
>> and as a non-administrative user in pgAdmin 4.
>>
>> PostgreSQL was installed using the EDB Mac OS X installer for PostgreSQL
>> version 12.3. The pgAdmin 4 version is 4.21.0. The Materialized View was
>> created using the Create Materialized View contextual menu and the
>> Materialized View was successfully saved. When the command to Refresh
>> Materialized View was issued using the contextual menu, the error was
>> generated about in about 0.25 sec. and the status code shown is: Failed
>> (exit code: 1). PgAdmin 4 was used to refresh 36 other Materialized Views
>> without error. This was the only case where an error occurred.
>>
>> The files llvmjit.so and llvmjit_types.bc are both installed in
>> /Library/PostgreSQL/lib/postgresql. File ownership for llvmjit.so is
>> root:daemon and permissions are set to rwxr-xr-x.
>>
>>
>
> --
> Sandeep Thakkar
>
>
>

--
Sandeep Thakkar