orafce bug issue
Hi Team ,
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
AIBE01PR=#
==> ls
adminpack.so dict_xsyn.so jsonb_plpython2.so
libpgtypes.so.3 passwordcheck.so pltcl.so
utf8_and_cyrillic.so
amcheck.so earthdistance.so latin2_and_win1250.so
libpgtypes.so.3.11 pg_buffercache.so postgres_fdw.so
utf8_and_euc2004.so
ascii_and_mic.so euc2004_sjis2004.so latin_and_mic.so libpq.a
pgcrypto.so refint.so utf8_and_euc_cn.so
auth_delay.so euc_cn_and_mic.so libecpg.a libpq.so
pg_freespacemap.so seg.so utf8_and_euc_jp.so
auto_explain.so euc_jp_and_sjis.so libecpg_compat.a
libpq.so.5 pg_hint_plan.so sepgsql.so
utf8_and_euc_kr.so
autoinc.so euc_kr_and_mic.so libecpg_compat.so
libpq.so.5.11 pgoutput.so sslinfo.so
utf8_and_euc_tw.so
bitcode euc_tw_and_big5.so libecpg_compat.so.3
libpqwalreceiver.so pg_prewarm.so tablefunc.so
utf8_and_gb18030.so
bloom.so file_fdw.so libecpg_compat.so.3.11
llvmjit.so pgrowlocks.so tcn.so
utf8_and_gbk.so
btree_gin.so fuzzystrmatch.so libecpg.so
llvmjit_types.bc pg_stat_statements.so tds_fdw.so
utf8_and_iso8859_1.so
btree_gist.so hstore_plperl.so libecpg.so.6 lo.so
pgstattuple.so test_decoding.so utf8_and_iso8859.so
citext.so hstore_plpython2.so libecpg.so.6.11
ltree_plpython2.so pg_trgm.so timetravel.so
utf8_and_johab.so
cube.so hstore.so libpgcommon.a ltree.so
pg_visibility.so tsm_system_rows.so utf8_and_sjis2004.so
cyrillic_and_mic.so insert_username.so libpgfeutils.a
moddatetime.so pgxml.so tsm_system_time.so
utf8_and_sjis.so
dblink.so _int.so libpgport.a
oracle_fdw.so pgxs unaccent.so
utf8_and_uhc.so
dict_int.so isn.so libpgtypes.a *
orafce.so * pkgconfig utf8_and_ascii.so
utf8_and_win.so
dict_snowball.so jsonb_plperl.so libpgtypes.so
pageinspect.so plpgsql.so utf8_and_big5.so
uuid-ossp.so
postgres@brurhenppp001.enterprisenet.org:/usr/pgsql-11/lib
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426
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
Hi Tom,
Thanks for the update and please let me know how can we check the version
and incompatibility.
*orafce | 3.8 | public | Functions and operators
that emulate a subset of functions and packages from the Oracle RDBMS* for
another one server i created successfully this time only getting error for
other server.
regards, prakash.
On Thu, May 2, 2019 at 7:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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: DatumGetFloat4Perhaps 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
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426
čt 2. 5. 2019 v 16:53 odesílatel Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> napsal:
Hi Tom,
Thanks for the update and please let me know how can we check the version
and incompatibility.*orafce | 3.8 | public | Functions and
operators that emulate a subset of functions and packages from the Oracle
RDBMS* for another one server i created successfully this time only
getting error for other server.
Orafce 3.8 is fresh, but nobody knows from this number for what version of
Postgres this dll was compiled.
If you want Orafce, you have to find package that support Postgres that you
use - or compile Orafce from source files against dev files of PostgreSQL
that you use.
Regards
Pavel Stehule
Show quoted text
regards, prakash.
On Thu, May 2, 2019 at 7:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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: DatumGetFloat4Perhaps 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
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
call : +91-8939599426
Hi Pavel and tom,
Thanks for your support now am able to create the extesnion.
Regards,
Prakash.r
On Thu, May 2, 2019 at 11:15 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote:
čt 2. 5. 2019 v 16:53 odesílatel Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> napsal:Hi Tom,
Thanks for the update and please let me know how can we check the version
and incompatibility.*orafce | 3.8 | public | Functions and
operators that emulate a subset of functions and packages from the Oracle
RDBMS* for another one server i created successfully this time only
getting error for other server.Orafce 3.8 is fresh, but nobody knows from this number for what version of
Postgres this dll was compiled.If you want Orafce, you have to find package that support Postgres that
you use - or compile Orafce from source files against dev files of
PostgreSQL that you use.Regards
Pavel Stehule
regards, prakash.
On Thu, May 2, 2019 at 7:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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: DatumGetFloat4Perhaps 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
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
call : +91-8939599426
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426