[PostGIS] #6072: loader scripts for os type 'sh' do not create schema tiger_data

PostGIS trac at osgeo.org
Thu Apr 16 04:57:03 PDT 2026


#6072: loader scripts for os type 'sh' do not create schema tiger_data
----------------------------+---------------------------
 Reporter:  epolkerman      |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  low             |  Milestone:  PostGIS 3.6.3
Component:  tiger geocoder  |    Version:  3.6.x
 Keywords:                  |
----------------------------+---------------------------
 As of issue #6049 the postgis_tiger_geocoder extension does not create the
 schema tiger_data anymore.

 In stead the tiger_data schema should be created by the loader scripts
 when executed.

 However for os type 'sh' (unix/linux) this is not the case: ERROR:  schema
 "tiger_data" does not exist

 In the extension sql file it can be seen that the part creating the schema
 is only inserted in table 'loader_platform' for os 'windows':

 %PSQL% -c "DO language ''plpgsql'' $$ BEGIN IF NOT EXISTS (SELECT * FROM
 information_schema.schemata WHERE schema_name = ''${data_schema}'' ) THEN
 CREATE SCHEMA ${data_schema}; END IF;  END $$"

 This is missing in the insert for table 'loader_platform' for os 'sh'
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6072>
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