[postgis-tickets] [PostGIS] #3460: Upgrade to 2.2 doesn't adjust size of pgis_abs type

[PostGIS]

#3460: Upgrade to 2.2 doesn't adjust size of pgis_abs type
----------------------+---------------------------
  Reporter:  dbaston  |      Owner:  dbaston
      Type:  defect   |     Status:  new
  Priority:  high     |  Milestone:  PostGIS 2.3.0
 Component:  postgis  |    Version:  2.2.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by dbaston):

 Thanks for the example; that indeed triggers a failure in an existing
 testcase:

 {{{
 dbaston at dbaston-lenovo:~/dev/postgis$ regress/run_test.pl --extension
 --upgrade-path 2.1.8--2.3.0dev regress/cluster.sql
 Upgrade path: 2.1.8 --> 2.3.0dev
 PATH is
 /home/dbaston/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
 Checking for shp2pgsql ... found
 Checking for pgsql2shp ... found
 Checking for raster2pgsql ... found
 TMPDIR is /tmp/pgis_reg
 Creating database 'postgis_reg'
 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis VERSION '2.1.8'
 Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
 TO '2.3.0dev'
 PostgreSQL 9.3.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
 4.8.2-19ubuntu1) 4.8.2, 64-bit
   Postgis 2.3.0dev - r14745 - 2016-03-05 01:09:27
   scripts 2.3.0dev r14745
   raster scripts 2.3.0dev r14745
   GEOS: 3.6.0dev-CAPI-1.10.0 r4118
   PROJ: Rel. 4.8.0, 6 March 2012
   GDAL: GDAL 1.10.1, released 2013/08/26

 Running tests

  regress/cluster .. failed (diff expected obtained:
 /tmp/pgis_reg/test_1_diff)
  uninstall .. ok (4112)

 Run tests: 2
 Failed: 1
 }}}

 It looks like the type update could be added to
 {{{postgis_drop_before.sql}}}, {{{postgis_drop_after.sql}}}, or inlined in
 {{{postgis_proc_upgrade.pl}}}.  Or I could add a
 {{{postgis_miscellaneous_hacks.sql}}}.

 Any objections to me adding it to {{{postgis_drop_after.sql}}} ? (this
 makes the above test pass)

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