[postgis-tickets] [PostGIS] #5359: PG16 schema qualify use of fuzzystrmatch in postgis_tiger_geocoder and some postgis

PostGIS trac at osgeo.org
Sat Jun 24 18:47:26 PDT 2023


#5359: PG16 schema qualify use of fuzzystrmatch in postgis_tiger_geocoder and some
postgis
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  enhancement     |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.4.0
 Component:  tiger geocoder  |    Version:  master
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Comment (by robe):

 I'm still trying to think the best way to do this.

 I'm thinking of explicitly using the new syntax in the current scripts and
 then a perl script that will strip them off for < 16 and keep for PG >=
 16.

 Note this feature will use the feature I authored that's already been
 committed to PG 16
 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=72a5b1fc880481914da2d4233077438dd87840ca

 so ideally the perl script would also look at the control file, and for
 each required extension in the control file, do a @extschema:name@  where
 name is each required extension.

 So in case of postgis_tiger_geocoder it will look for
 @extschema:postgis at ., @extschema:fuzzystrmatch at .
 and strip those references for PG < 16 and leave alone for PG >= 16
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5359#comment:2>
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.


More information about the postgis-tickets mailing list