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.


  1. download or 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

Monday, November 28, 2022

pspg 5.6.0

I released pspg 5.6.0. There is only one (not too visible change). It allows to use true color themes in "konsole" terminal (when TERM) is xterm-direct.

Sunday, November 20, 2022

pspg and nushell

I very like the concept of nushell. The concept of Unix pipes is famous (still), but little bit aged (we have more resources than was possible 40 years ago). Working with multi-column data with classical Unix tools is fragile and really not very friendly. More time I asked why conceptual development stopped at 80 years. nushell allows to work well with relations. There is similar project relational pipes. In old times the Microsoft has something similar based on DAO

I didn't find C API of nushell (it is 100% rust oriented), so I cannot to support nushell in pspg directly, but support via CSV format works perfectly. 


and same result displayed in pspg:

Update: pspg 5.5.10 supports nushell formats (table_mode) rounded (default) and heavy. The conversion to csv is not necessary.

Wednesday, November 2, 2022

orafce 4.0.0

Today I released orafce 4.0.0

The big change is merging orafce_sql project - so now directly in orafce is possible to use dbms_sql package.

Second change is code cleaning - support for PostgreSQL 9.6 and 10 was removed.

Friday, October 7, 2022

pspg 5.5.8

I released new version of pspg . This release can be interesting for users that uses some BSD platforms (like FreeBSD). Unfortunately, these platforms doesn't support alternate screen, and then can users can see some unwanted visual effects, when pspg is closed. Most unwanted are chars of bottom menu in command line.

New pspg introduces set of options, that can be used in this situation: --on-exit-reset (reset terminal), --on-exit-clean (clean terminal) and --on-exit-erase-line (erase last (bottom line)).

Friday, April 15, 2022

Orafce 3.21.0

I released Orafce 3.21.0. In this release, the Oracle regexp functions regexp_instr and regexp_replace was backported (and little bit modified) from PostgreSQL 15. The C implementation is more faster, and much more robust than PLpgSQL implementation. The problem was not in just PL/pgSQL, but in some missing possibilities of PostgreSQL regexp API available from SQL or PL/pgSQL.

Attention, although the code was backported from Postgres, the behavior is little bit different for making higher compatibility with Oracle. There is little bit different handling NULL values.

Tuesday, April 5, 2022

New releases Orafce and plpgsql_check

 I released bugfix releases of plpgsql_check and Orafce.

Attention - In had to change signature of nvl2 function in Orafce. With this change, the behave is much more close to Oracle's nvl2 function.  Unfortunately, this change can break extension update when some users use nvl2 function in views.  The related views should be dropped first, and after extension update should be created again.