Opened 3 years ago

Closed 2 years ago

#5041 closed defect (fixed)

loader_generate_script generates script with invalid syntax

Reported by: naoko Owned by: robe
Priority: medium Milestone: PostGIS 3.1.5
Component: tiger geocoder Version: 2.5.x -- EOL
Keywords: Cc:

Description

loader_generate_script generated the following 2 lines which is invalid syntax ` ALTER TABLE tiger_staging.UT_tract RENAME geoid IF EXISTS TO tract_id; ALTER TABLE tiger_staging.UT_tract RENAME geoid10 IF EXISTS TO tract_id; `

also ` gisdb=# select table_name, lookup_name, process_order, lookup_name, level_state, load from tiger.loader_lookuptables where table_name LIKE 'tabblock%';

table_name | lookup_name | process_order | lookup_name | level_state | load


tabblock10 | tabblock | 11 | tabblock | t | f tabblock20 | tabblock20 | 11 | tabblock20 | t | t

(2 rows) ` cause the link to be created like this ` wget https://www2.census.gov/geo/tiger/TIGER2018/TABBLOCK20/tl_2018_49_tabblock20.zip —mirror —reject=html ` but tabblock20 do not exists but tabblock10 do.

Change History (5)

comment:1 by robe, 3 years ago

Milestone: PostGIS 3.2.0PostGIS 3.1.5

comment:2 by robe, 3 years ago

I think I might have fixed this already.

Just tested with PostGIS 3.1 branch loading UT.

And result

SELECT count(*) FROM tiger_data.ut_tabblock20;
 count
-------
 71207

Although tract seems messed up:

SELECT count(*) FROM tiger_data.ut_tract;
 count
-------
     0
Last edited 3 years ago by robe (previous) (diff)

comment:3 by Regina Obe <lr@…>, 3 years ago

In ebffbef5/git:

Fix invalid insert for tract. References #5041 for PostGIS 3.1.5

comment:4 by Regina Obe <lr@…>, 3 years ago

In bd15102/git:

Fix invalid tract load, turn off tabblock20 by default. References #5041 for PostGIS 3.2.1

comment:5 by pramsey, 2 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.