RE: REFRESH MATERIALIZED VIEW error - Mailing list pgsql-bugs

From Given, Robert A
Subject RE: REFRESH MATERIALIZED VIEW error
Date
Msg-id DM6PR03MB3497C89EF317157D5775DDEBA6CAA@DM6PR03MB3497.namprd03.prod.outlook.com
Whole thread Raw
In response to Re: REFRESH MATERIALIZED VIEW error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Thank you Tom!  We downloaded the file_fdw.so library and recompiled the Materialized views and the application is
runningnormally. 

Thank you for your insight!

Bob

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, October 4, 2023 5:04 PM
To: Given, Robert A <bgiven@bu.edu>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: REFRESH MATERIALIZED VIEW error

"Given, Robert A" <bgiven@bu.edu> writes:
> After an OS upgrade from CentOS 7 to RHEL 9.2, our Materialized Views are not getting refreshed. We are receiving
thiserror: 
>> From log...
> 2023-10-04 00:04:01.885 EDT [235717] ERROR:  could not access file
> "$libdir/file_fdw": No such file or directory

You didn't install the file_fdw.so library that underlies the file_fdw extension.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18147: ERROR: invalid perminfoindex 0 in RTE with relid xxxxx
Next
From: PG Bug reporting form
Date:
Subject: BUG #18148: Handle null in a date/time fields when passing empty arrays issue