Opened 5 years ago

Closed 5 years ago

#2502 closed defect (fixed)

postgis_full_version() not finding topology if not in search_path

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.0.5
Component: postgis Version: 2.0.x
Keywords: history Cc:

Description

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.

Change History (3)

comment:1 Changed 5 years ago by 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+ ?

comment:2 Changed 5 years ago by 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.

comment:3 Changed 5 years ago by strk

Keywords: history added
Milestone: PostGIS 2.0.5
Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.