[PostGIS] #5897: change postgis_tiger_geocoder to use typmod

[PostGIS]

#5897: change postgis_tiger_geocoder to use typmod
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  enhancement     |     Status:  closed
  Priority:  medium          |  Milestone:  PostGIS 3.6.0
 Component:  tiger geocoder  |    Version:  master
Resolution:  fixed           |   Keywords:
-----------------------------+---------------------------
Changes (by Regina Obe <lr@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"bc08546510ebfbd458c42f22dd696f50bd81ac95/git" bc08546/git]:
 {{{#!CommitTicketReference repository="git"
 revision="bc08546510ebfbd458c42f22dd696f50bd81ac95"
 SCHEMA qualify extension dependencies
 for PG16 and above for postgis_tiger_geocoder

  - schema qualify in scripts dependent extensions postgis, fuzzystrmatch
  - add a no_relocate clause to the .control file to prevent relocation
    of these for PG16 and above
  - Use for new installs typmod for geometry instead of constraints
  - Ignore regression.out files generated by installcheck

 Closes #5359
 Closes #5897
 Closes https://git.osgeo.org/gitea/postgis/postgis/pulls/260
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5897#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.