search

sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
862 stars 24 forks source link

Error: undefined symbol: pg_get_querydef #38

Closed koureasstavros closed 1 year ago

koureasstavros commented 1 year ago

I tried pg_ivm extension in Postgres15 and works as excepted. I tried also pg_ivm extension in Postgres14, after installation, running the command: CREATE EXTENSION pg_ivm; throws an error ERROR: could not load library "/usr/lib/postgresql/14/lib/pg_ivm.so": /usr/lib/postgresql/14/lib/pg_ivm.so: undefined symbol: pg_get_querydef

I think this function exists on PostgreSQL14 Any ideas?

yugo-n commented 1 year ago

Maybe, you missed to rebuild (make clean & make) pg_ivm before installation (make install) to PostgreSQL 14.

koureasstavros commented 1 year ago

Thanks, that was my issue, I had build it first for PG15 and make clean & make did the trick.