[postgis-tickets] [PostGIS] #5041: loader_generate_script generates script with invalid syntax

[PostGIS]

#5041: loader_generate_script generates script with invalid syntax
----------------------------+---------------------------
 Reporter:  naoko           |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 3.2.0
Component:  tiger geocoder  |    Version:  2.5.x
 Keywords:                  |
----------------------------+---------------------------
 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.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5041>
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.