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

 Script to reproduce, which can be tested with different versions:
 {{{
 #!/bin/sh

 VER='2.1.3'
 if test -n "$1"; then
   VER="$1"
 fi

 dropdb tt
 createdb tt
 cat<<EOF | psql tt
 create extension postgis version '$VER';
 create extension fuzzystrmatch;
 create extension postgis_tiger_geocoder version '$VER';
 EOF
 pg_dump -Fc tt > tt.dump
 dropdb tt
 createdb tt
 pg_restore -d tt tt.dump
 }}}


 For me it fails with a single error in 2.1.3, 2.1.8dev and 2.1.9dev
 (duplicate 'debug_geocode_address' key in geocode_settings_pkey)

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