pgsql_tweaks 0.10.6 released


pgsql_tweaks is a bundle of functions and views for PostgreSQL

Published on September 28, 2024 by Stefanie Janine Stölting

PostgreSQL Extension pgsql_tweaks

1 min READ

pgsql_tweaks is a bundle of functions and views for PostgreSQL

The soucre code is available on GitLab, a mirror is hosted on GitHub.
One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

General changes

Due to the problem that pgTAP is using the same function name, is_empty, there was a problem when pgTAP has been installed before pgsql-tweaks.

To solve this problem and to not break existing code, I decided to install the function under a different name, is_empty_b, when pgTAP is already installed.

When pgTAP is not installed, the function name is still is_empty to not break existing code using the function.

There is also a differnt in the the functions between the two implementations. While the pgTAP function returns text, the pgsql-tweaks function returns a boolean result.

I have also created an issue at the pgTAP issue tracker. I can only solve the problem of pgTAP has been installed before pgsql-tweaks. But when pgTAP is installed after pgsql-tweaks it might cause a problem with the installation of pgTAP.

There have been no new or changed features, therefore this is only a minor release.



Author: Stefanie Janine Stölting