pgtap icon indicating copy to clipboard operation
pgtap copied to clipboard

Problem with function is_empty

Open sjstoelting opened this issue 4 months ago • 3 comments

The problem is, that another extension, pgsql-tweaks, is installing the function is_empty, but with different returning results, pgtap is returning text, pgsql-tweaks is returning a boolean, please see is_empty source. In addition the installation of either one might fail, if the other one is already installed.

I can and will solve the problem by changing the name from is_empty to is_empty_b (the b for the boolean result), if pgtap is already installed. But it would not solve the problem to install pgtap, if pgsql-tweaks is installed.

And overwriting each others function might cause problems, as they differ in their returning data type.

Just in case, the pg-tweaks repository on GitHub is only a mirror of the one on GitLab.

sjstoelting avatar Sep 28 '24 11:09 sjstoelting