[PostGIS] #5998: Ensure postgis_tiger_geocoder packaged tables are created by the extension

[PostGIS]

#5998: Ensure postgis_tiger_geocoder packaged tables are created by the extension
-----------------------------+----------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  patch           |     Status:  closed
  Priority:  medium          |  Milestone:  PostGIS 3.0.12
 Component:  tiger geocoder  |    Version:  3.5.x
Resolution:  fixed           |   Keywords:
-----------------------------+----------------------------
Changes (by tbussmann):

 * cc: tbussmann (added)

Comment:

 The backported patch to the 3.2 and 3.3 branches unfortunately did break
 upgrades from previous versions.

 For `make -C postgis-3.2.9/extensions/postgis_tiger_geocoder installcheck`
 the `test test-upgrade` fails with:


 {{{
 ---
 /Users/quickfix/Documents/_git/PostgresApp/src-14/postgis-3.2.9/extensions/postgis_tiger_geocoder/expected
 /test-upgrade.out 2026-02-11 02:01:47.000000000 +0100
 +++
 /Users/quickfix/Documents/_git/PostgresApp/src-14/postgis-3.2.9/extensions/postgis_tiger_geocoder/results
 /test-upgrade.out  2026-02-11 10:08:36.000000000 +0100
 @@ -1 +1,5 @@
  ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "3.2.9next"
 +ERROR:  schema tiger_data is not a member of extension
 "postgis_tiger_geocoder"
 +DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip
 object creation if the conflicting object is one that it already owns.
 +CONTEXT:  SQL statement "CREATE SCHEMA IF NOT EXISTS tiger_data"
 +PL/pgSQL function inline_code_block line 3 at SQL statement
 }}}

 I also manually verified `postgis_extensions_upgrade()` does fail to
 update from 3.2.8 to 3.2.9 if the `postgis_tiger_geocoder` extension is
 installed. 3.4 and newer seem not to be affected.

 The `installcheck` target does not descend into sub directories, so these
 regression tests need to be manually started - this was closed as wontfix
 in #5813
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5998#comment:15>
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.