postgis_full_version() not finding topology if not in search_path

[strk]

If "topology" schema is not in your search_path, the "postgis_full_version()" function fails to realize that the topology is installed.

It is common for "topology" to be not in path when the extension is initially enabled.

[strk]

It turns out that the "postgis_topology_scripts_installed" function is installed in the "public" schema by topology.sql but in the topology schema by CREATE EXTENSION.

I guess the correct fix for this would be to ensure the function is always created in the topology schema, and update the postgis_full_version accordingly. But… would such change be acceptable in anything but 2.2+ ?

[robe]

This is clearly a bug and probably one you run into when you are switching from non-extension to extension install?

It's borderline. I say fix it since its clearly broken and the behavior of extension vs. non-extension is different which is a big no no already.

[strk]

r12012 in trunk (2.2.0), r12013 in 2.1 branch (2.1.1), r12014 in 2.0 branch (2.0.5)