[postgis-tickets] [PostGIS] #3727: Hard upgrade failed - pg_restore: [archiver] could not find entry for ID 6

[PostGIS]

#3727: Hard upgrade failed - pg_restore: [archiver] could not find entry for ID 6
------------------------------------+---------------------------
  Reporter:  milosh                 |      Owner:  strk
      Type:  defect                 |     Status:  closed
  Priority:  medium                 |  Milestone:  PostGIS 2.3.3
 Component:  build/upgrade/install  |    Version:  2.3.x
Resolution:  invalid                |   Keywords:
------------------------------------+---------------------------
Changes (by milosh):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 Found the root cause:

 Foreign Key constraint with new line in its name created by hand in the
 distant past by copypasting sql from wrapped terminal window.

 ALTER TABLE "provoz_provozovna" ADD CONSTRAINT
 "infrastruktura_id_refs_id_4e49f6
 6e" FOREIGN KEY ("infrastruktura_id") REFERENCES "provoz_infrastruktura"
 ("id")

 This will appear as:

 15128; 2606 5687308 FK CONSTRAINT public infrastruktura_id_refs_id_4e49f6
 6e postgres

 in the TOC file and the archiver will fail trying to lookup item ID "6" in
 the backup.

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