Pages

▼

Monday, December 21, 2020

Orafce 3.14.0 released

I released Orafce 3.14.0. It is mostly bugfix release. Only implementation of unistr function is new. The most important fixed issue was missing dependency between functions (n)varchar2 and (n)varchar2_transform. An result of this missing dependency was bad order of functions in dump used by binary upgrade - and at end the binary upgrade was broken. After fixing the binary upgrade between major Postgres releases (by pg_upgrade) is possible.
at

5 comments:

  1. UnknownDecember 22, 2020 at 4:57 AM

    As a guy you just lurks around here, it would be nice to know what Orafce is. My corporate policy blocks GitHub So I can't follow the link to find out.

    ReplyDelete
  2. Pavel StěhuleDecember 22, 2020 at 5:31 AM

    @Unknown - Orafce is an extension for Postgres. It emulates Oracle's most used functions, some Oracle's types like nvarchar2 or varchar2 or data, and some Oracle's packages.

    ReplyDelete
  3. 고지환January 14, 2021 at 5:57 PM

    Could you post complied orafce 3.14.0 with Postgres 13.1 ? or give me some hint to build in Windows 10 ?

    I tried to build with https://www.highgo.ca/2020/05/15/build-postgresql-and-extension-on-windows/
    but failed. Most of errors are like this. " sqlscan.l(439,6): error C2065: 'orafce_sql_yylval': undeclared identifier "

    ReplyDelete
  4. Pavel StěhuleJanuary 15, 2021 at 9:17 PM

    I didn't test compilation on MS Windows yet.

    ReplyDelete
  5. Pavel StěhuleJanuary 24, 2021 at 12:41 PM

    @소풍, 그 위대한 여정 you should not to compile sqlscan.c directly. The build instruction are in document. I checked build for PostgreSQL 13, and it should to work. You can download compiled dll from link.

    ReplyDelete