Sunday, October 31, 2021

Orafce 3.17.0

I released Orafce 3.17.0. This is bugfix only release. Giles Darold wrote a patch that fixes orafce's regexp functions for NULL arguments.

Tuesday, October 12, 2021

pspg 5.4.1 released

I released bugfix release of pspg. The problem with copy to clipboard on macos (using by pbcopy) is fixed in this release.

Monday, October 11, 2021

Orafce 3.16.2 for Postgres 12, 13 and 14 for Microsoft Windows

I made dll of orafce 3.16.2. These dll are available from archive orafce-3.16.2-x64-win.zip Instalation is simple. Copy related dll file to directory Program files/Postgres/version/lib and rename this dll just to orafce. Next, copy orafce.control and orafce--3.16.sql to Program files/Postgres/version/share/extension. Last step is executing command CREATE EXTENSION orafce in the database, where you want to use orafce. It can require redistributable runtime for Visual Studio 2019. Usually an good idea is set SEARCH_PATH to include schema oracle.

plpgsql_check 2.0.4 for Microsoft Windows and Postgres 12, 13 and 14.

I made dll of plpgsql_check 2.0.4. These dll are available from archive plpgsql_check-2.0.4-x64-win.zip Instalation is simple. Copy related dll file to directory Program files/Postgres/version/lib and rename this dll just to plpgsql_check. Next, copy plpgsql_check.control and plpgsql_check-2.0.sql to Program files/Postgres/version/share/extension. Last step is executing command CREATE EXTENSION plpgsql_check in the database, where you want to use plpgsql_check. It can require redistributable runtime for Visual Studio 2019.

Sunday, October 10, 2021

pspg 5.4.0

I released pspg version 5.4.0.. In this release there is an possibility to customize buildin color themes:
template = 1
template_menu = 3

background = black, white
data = black, white
label = black, white, italic, bold
border = #000000, white
footer = lightgray, white
cursor_data = blue, white, italic, bold, dim, reverse
cursor_border = blue, blue , italic, bold, dim, reverse
cursor_label = blue, white, italic, bold, dim, reverse
cursor_footer = blue, white, italic, bold, dim, reverse
cursor_bookmark = red, white, italic, bold, dim, reverse
cross_cursor = white, blue, italic, bold
cross_cursor_border = brightblue, blue
status_bar = black, lightgray
title = black, lightgray
scrollbar_arrows = black, white
scrollbar_background = lightgray, white
scrollbar_slider = white, gray