[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):

 Another error is in duplicated value in a supposed primary key value
 (table not tagged as belonging to extension?):
 {{{
 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.
 }}}

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