[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
Resolution:                  |   Keywords:
-----------------------------+---------------------------

Comment (by strk):

 also works with default_version=2.2.2dev.

 It takes default_version=2.1.9dev to reproduce, from "2.1.3" to
 "2.1.9dev".
 {{{
 SET
 CREATE EXTENSION
 CREATE EXTENSION
 CREATE EXTENSION
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 3344; 0 51783822 TABLE
 DATA geocode_settings strk
 pg_restore: [archiver (db)] COPY failed for table "geocode_settings":
 ERROR:  duplicate key value violates unique constraint
 "geocode_settings_pkey"
 DETAIL:  Key (name)=(debug_geocode_address) already exists.
 CONTEXT:  COPY geocode_settings, line 1
 WARNING: errors ignored on restore: 1
 }}}

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