[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
 Keywords:                         |
-----------------------------------+---------------------------
 See https://github.com/postgis/docker-postgis/issues/288

 The problem is that ALTER DATABASE does not change the `reset_val` in
 pg_settings, which is used by extensions to fetch the "current" value of
 search_path:

 {{{
 test_issue288=# create extension postgis_tiger_geocoder;
 CREATE EXTENSION
 test_issue288=# select setting, boot_val, reset_val from
 pg_catalog.pg_settings WHERE name = 'search_path';
 -[ RECORD 1 ]---------------------
 setting   | "$user", public, tiger
 boot_val  | "$user", public
 reset_val | "$user", public
 }}}

 You can see the `setting` field is updated, but not the `reset_val`, which
 is instead only updated on next reconnection.

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