Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> writes:
> while we are creating the orafce extension getting below error.
> AIBE01PR=# create extension orafce;
> ERROR: could not load library "/usr/pgsql-11/lib/orafce.so":
> /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4
Perhaps that extension was compiled against some old version of
Postgres (probably 9.6 or earlier)? Ideally you'd get a version
incompatibility complaint first ... but unfortunately if the dynamic
linker is unhappy, that's going to come out before we can find out
what version the .so is for.
regards, tom lane