[postgis-tickets] [PostGIS] #3430: dump/restore of tiger geocoder extension fails

[PostGIS]

#3430: dump/restore of tiger geocoder extension fails
----------------------------+---------------------------
 Reporter:  strk            |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.1.9
Component:  tiger geocoder  |    Version:  2.1.x
 Keywords:                  |
----------------------------+---------------------------
 The dump contains a few tiger geocoder functions that cannot be restored:
 {{{
 246; 3079 46281 EXTENSION - postgis_tiger_geocoder
 3629; 0 0 COMMENT - EXTENSION postgis_tiger_geocoder
 ...
 292; 1255 46570 FUNCTION tiger create_census_base_tables() docker
 290; 1255 46295 FUNCTION tiger get_geocode_setting(text) docker
 3632; 0 0 COMMENT tiger FUNCTION get_geocode_setting(setting_name text)
 docker
 289; 1255 46286 FUNCTION tiger install_geocode_settings() docker
 293; 1255 46571 FUNCTION tiger loader_generate_census_script(text[], text)
 docker
 3633; 0 0 COMMENT tiger FUNCTION
 loader_generate_census_script(param_states text[], os text) docker
 291; 1255 46296 FUNCTION tiger set_geocode_setting(text, text) docker
 3634; 0 0 COMMENT tiger FUNCTION set_geocode_setting(setting_name text,
 setting_value text) docker
 312; 1255 46696 FUNCTION tiger topology_load_tiger(character varying,
 character varying, character varying) docker
 3635; 0 0 COMMENT tiger FUNCTION topology_load_tiger(toponame character
 varying, region_type character varying, region_id character varying)
 docker
 }}}

 Functions creation fails as already existing (due to earlier CREATE
 EXTENSION, I'd think):
 {{{
 pg_restore: [archiver (db)] could not execute query: ERROR:  function
 "create_census_base_tables" already exists with same argument types
 pg_restore: [archiver (db)] could not execute query: ERROR:  function
 "get_geocode_setting" already exists with same argument types
 pg_restore: [archiver (db)] could not execute query: ERROR:  function
 "install_geocode_settings" already exists with same argument types
 pg_restore: [archiver (db)] could not execute query: ERROR:  function
 "loader_generate_census_script" already exists with same argument types
 pg_restore: [archiver (db)] could not execute query: ERROR:  function
 "topology_load_tiger" already exists with same argument types
 }}}

 The dump was taken and restored from and to a 9.3/2.1.8 setup

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