Pages

Friday, December 2, 2022

prepared dll of orafce 4.0.1 and plpgsql_check 2.2.5 for PostgreSQL 14 and PostgreSQL 15

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 14 and PostgreSQL 15.

Setup:

  1. download orafce-4.0.1.zip or plpgsql_check-2.2.5.zip and extract files
  2. copy related dll file to PostgreSQL lib directory (NN is number of pg release)
    orafce-NN.dll -> "c:\Program Files\PostgreSQL\NN\lib"
  3. remove suffix "-14" or "-15" from dll file
    orafce-NN.dll -> orafce.dll
  4. copy *.sql and *.control files to extension directory
    *.sql, *.control -> "c:\Program Files\PostgreSQL\NN\share\extension"
  5. execute with super user rights SQL command CREATE EXTENSION
    CREATE EXTENSION orafce;

7 comments:

  1. Hi Pavel. Where is the latest dll for PostgreSQL 13? Thank you.

    ReplyDelete
  2. Hi Pavel. Will this work for PostgreSQL 13? I badly need the latest one for that version which includes the oracle.decode function. Thank you.

    ReplyDelete
  3. I usually do build of orafce just for latest PostgreSQL releases. There can be an exception, when I have some paying customers.

    ReplyDelete
  4. Hi Pavel,

    Do you have compiled version of orafce.so(Unix instead of Windwos .dll file) for Postgresql 15?

    ReplyDelete
  5. Helo Pavel,
    Are you going to prepare dll for PostgreSQL 16?

    ReplyDelete
  6. @Mart - yes, I'll build these dll probably next month

    ReplyDelete