[postgis-tickets] [PostGIS] #5125: Creating both topology and tiger extension in same session contend search_path

[PostGIS]

#5125: Creating both topology and tiger extension in same session contend
search_path
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.3.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by ImreSamu):

 I am testing the master branch with my local updated docker
 * `postgis/postgis:14-master`
   * `ENV POSTGIS_GIT_HASH 6a6cc54bdf1315da8e8c8401575c179aa8727daf`

 - with the "old" and the new patched "initdb-postgis.sh"

 And I receive this log with `CREATE EXTENSION IF NOT EXISTS
 postgis_tiger_geocoder;`

 {{{
 postgres=# CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;
 CREATE EXTENSION
 postgres=# CREATE EXTENSION IF NOT EXISTS 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
 postgres=#

 }}}


 I have received the same docker-postgis CI/CD error log "Build docker
 image for 14-master variant default" ( with the new "initdb-postgis.sh" )
 :

 https://github.com/postgis/docker-
 postgis/runs/5883910585?check_suite_focus=true


 And replicated with local docker environment: (with the new patched
 "initdb-postgis.sh")

 {{{
 git clone https://github.com/postgis/docker-postgis.git
 cd docker-postgis
 make update
 make build-14-master
 make test-14-master
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5125#comment:6>
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.