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