[postgis-tickets] [PostGIS] #3443: PostGIS dump/restore fails with duplicate key in spatial_ref_sys

[PostGIS]

#3443: PostGIS dump/restore fails with duplicate key in spatial_ref_sys
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.2.2
Component:  postgis  |    Version:  2.2.x
 Keywords:           |
---------------------+---------------------------
 Dumping and restoring a database after CREATE EXTENSION POSTGIS fails with
 this:
 {{{
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 3174; 0 51657944 TABLE
 DATA spatial_ref_sys strk
 pg_restore: [archiver (db)] COPY failed for table "spatial_ref_sys":
 ERROR:  duplicate key value violates unique constraint
 "spatial_ref_sys_pkey"
 DETAIL:  Key (srid)=(7041) already exists.
 CONTEXT:  COPY spatial_ref_sys, line 1
 }}}

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