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

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