Re: orafce bug issue

čt 2. 5. 2019 v 16:53 odesílatel Prakash Ramakrishnan <
prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)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
>>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
>