[postgis-tickets] [PostGIS] #5126: tiger geocoder is failing on winnie

[PostGIS]

#5126: tiger geocoder is failing on winnie
----------------------------+---------------------------
 Reporter:  robe            |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  blocker         |  Milestone:  PostGIS 3.3.0
Component:  tiger geocoder  |    Version:  3.2.x
 Keywords:                  |
----------------------------+---------------------------
 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
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5126>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.