loader_generate_script generates script with invalid syntax

[naoko]

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.

[robe]

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

[Regina Obe <lr@…>]

In ebffbef5/git:

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

[Regina Obe <lr@…>]

In bd15102/git:

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