[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