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.

5 Comments:

At December 22, 2020 at 4:57 AM , Blogger Unknown said...

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.

 
At December 22, 2020 at 5:31 AM , Blogger Pavel Stěhule said...

@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.

 
At January 14, 2021 at 5:57 PM , Blogger 고지환 said...

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 "

 
At January 15, 2021 at 9:17 PM , Blogger Pavel Stěhule said...

I didn't test compilation on MS Windows yet.

 
At January 24, 2021 at 12:41 PM , Blogger Pavel Stěhule said...

@소풍, 그 위대한 여정 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.

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home