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

 Great, I can reproduce the problem if I set typlen=8 in the system table.

 {{{
 UPDATE pg_type SET typlen=8 WHERE typname='pgis_abs';
 SELECT ST_ClusterWithin(geom, 0.1) FROM (SELECT ST_MakePoint(random(),
 random()) AS geom FROM generate_series(1, 100)) sq;
 }}}
 gives
 {{{
 ERROR:  Tolerance not defined
 }}}

 If I set typlen to 16 after this, the query succeeds.

 I don't think we want an automated test for this though, because it's
 possible to not get an error even with typlen=8.  If I set it to 16, run a
 query, and then go back to 8, I don't get an error.  It's only if it's set
 to 8 at the beginning of the session.  Even the report we got on postgis-
 users said the problem was intermittent, which I think is to be expected.

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