Opened 3 years ago
Closed 3 years ago
#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: |
Description
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 , 3 years ago
comment:3 by , 3 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
This broke as a result of #5125