[postgis-tickets] [PostGIS] #3444: Add dump/restore testing

[PostGIS]

#3444: Add dump/restore testing
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  robe
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 2.3.0
 Component:  buildbots    |    Version:  2.2.x
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by strk):

 With search_path tweaked by run_test.pl (r14656 and r14655) there are
 still failures in topology, which I believe have to do with tuples order.
 It's surprising how a dump/reload can change order of things, despite it
 happening _before_ loading any data !

 {{{
 ../../regress/run_test.pl --dumprestore --topology -v
 regress/st_remedgemodface.sql
 ...
 Dumping and restoring database 'postgis_reg'
 PostgreSQL 9.3.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
 4.8.2-19ubuntu1) 4.8.2, 64-bit
   Postgis 2.3.0dev - r14654 - 2016-02-09 12:02:08
   scripts 2.3.0dev r14654
   GEOS: 3.6.0dev-CAPI-1.10.0 r4138
   PROJ: Rel. 4.8.0, 6 March 2012

 Running tests

  regress/st_remedgemodface .. failed (diff expected obtained:
 /tmp/pgis_reg/test_1_diff)
 -----------------------------------------------------------------------------
 --- regress/st_remedgemodface_expected  2015-08-07 18:04:52.984242613
 +0200
 +++ /tmp/pgis_reg/test_1_out    2016-02-09 19:27:37.319120020 +0100
 @@ -10,175 +10,175 @@
  ERROR:  SQL/MM Spatial exception - non-existent edge 0
  ERROR:  SQL/MM Spatial exception - non-existent edge 143
  RM(25)|1
 -RM(25)/nodes|+|21|1
  RM(25)/nodes|-|21|
 -RM(25)/nodes|+|22|1
 +RM(25)/nodes|+|21|1
  RM(25)/nodes|-|22|
 +RM(25)/nodes|+|22|1
  RM(25)/edges|-|25|-25|25|1|1
  RM(4)|0
 -RM(4)/nodes|+|5|0
  RM(4)/nodes|-|5|
 +RM(4)/nodes|+|5|0
  RM(4)/edges|-|4|-5|4|0|0
 -RM(4)/edges|+|5|-5|5|0|0
  RM(4)/edges|-|5|-4|5|0|0
 +RM(4)/edges|+|5|-5|5|0|0
  RM(26)|1
 -RM(26)/nodes|+|20|1
  RM(26)/nodes|-|20|
 +RM(26)/nodes|+|20|1
  RM(26)/edges|-|26|26|-26|9|1
  RM(26)/faces|-|9|SRID=4326;POLYGON((4 31,4 34,7 34,7 31,4 31))
 ...
 }}}

 Dropping the --dumprestore switch makes the test succeed

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