Error with FT post build from parquet build using duckdb_fdw 1.12

[MicroMouse25]

Hi,

Have found an issue with this error produced on ft created using duckdb_fdw, have pg_parquet also installed, so don't know if there is any conflict betweeen extensions, but need the fdw ability for referencing the parquet files created.

This is the error given :

ERROR: SQL error during prepare: Catalog Error: Table Function with name "read_parquet" is not in the catalog, but it exists in the parquet extension.

Please try installing and loading the parquet extension by running:
INSTALL parquet;
LOAD parquet;

Alternatively, consider enabling auto-install and auto-load by running:
SET autoinstall_known_extensions=1;
SET autoload_known_extensions=1; SELECT "vendor_id", "pickup_at", "dropoff_at", "passenger_count", "trip_distance", "rate_code_id", "store_and_fwd_flag", "pickup_location_id", "dropoff_location_id", "payment_type", "fare_amount", "extra", "mta_tax", "tip_amount", "tolls_amount", "improvement_surcharge", "total_amount", "congestion_surcharge" FROM read_parquet("/lake/d-l-datawh01_parquet/taxi_2019_04.parquet") LIMIT 100

SQL state: HV00L

With read permission removed, still get HV00L error.

Have tried
1). Placing file in home directory
2). In postgres user accessible locations
3). tmp

All the same error, have restarted the instance.

Running Pg16.8 and RHEL 8.5 used this article for ref : https://medium.com/@ahuarte/loading-parquet-in-postgresql-via-duckdb-testing-queries-and-exploring-the-core-1d667ae67dc2