[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:  reopened
  Priority:  medium          |  Milestone:  PostGIS 3.0.12
 Component:  tiger geocoder  |    Version:  3.5.x
Resolution:                  |   Keywords:
-----------------------------+----------------------------
Comment (by robe):

 Replying to [comment:15 tbussmann]:
 > 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


 I might have missed committing my last fix to the patch on these branches.
 I removed the tiger_data schema from the extension cause it is supposed to
 be created by users.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5998#comment:17>
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.