Creating both topology and tiger extension in same session contend search_path
|Reported by:||strk||Owned by:||strk|
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.