#5126 closed defect (fixed)

tiger geocoder is failing on winnie

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 3.3.0
Component: tiger geocoder Version: 3.2.x
Keywords: Cc:


Just noticed winnie is failing with this error. Assume this is a result of strk's resent search_path changes.

============== installing postgis_tiger_geocoder      ==============
ERROR:  column "c" does not exist
LINE 10:  SELECT regexp_replace(c, '^search_path=', '')
QUERY:  WITH settings AS (
		SELECT unnest(setconfig) config
		FROM pg_catalog.pg_db_role_setting
		WHERE setdatabase = (
			SELECT oid
			FROM pg_catalog.pg_database
			WHERE datname = current_database()
		) and setrole = 0
	SELECT regexp_replace(c, '^search_path=', '')
	FROM settings WHERE c like 'search_path=%'
CONTEXT:  PL/pgSQL function postgis_extension_addtosearchpath(character varying) line 7 at SQL statement
command failed: "E:/jenkins/postgresql/rel/pg14w64gcc81/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"postgis_tiger_geocoder\"" "contrib_regression"
make: *** [E:/jenkins/postgresql/rel/pg14w64gcc81/lib/pgxs/src/makefiles/pgxs.mk:433: installcheck] Error 2

Change History (3)

comment:1 by robe, 18 months ago

This broke as a result of #5125

comment:2 by Regina Obe <lr@…>, 18 months ago

In cbf5283/git:

Fix search path function. References #5125 and #5126 for PostGIS 3.3.0

comment:3 by robe, 18 months ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.