[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:  pramsey
      Type:  defect   |     Status:  new
  Priority:  high     |  Milestone:  PostGIS 2.2.2
 Component:  postgis  |    Version:  2.2.x
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by dbaston:

Old description:

> The size of the {{{pgis_abs}}} type was changed from 8 bytes to 16 bytes
> in 2.2.0.  It doesn't appear that the upgrade procedure handles this, so
> if you upgrade to 2.2.x from a previous version, Postgres would still
> think the size is 8 bytes.
>
> I haven't been able to show this, because I can't actually perform an
> upgrade from 2.1.x to more recent versions due to #3429.  But this seems
> like it would explain the following issue reported to postgis-users:
>

> On Wed, Feb 17, 2016 at 01:44:54PM +0100, Ronnie Lassche wrote:
> > I’m trying to use the new st_clusterwithin function, but it keeps
> failing.
> >
> > I’ve tried to cluster 20 points with the following query.
> >
> > SELECT ST_ClusterWithin(geom, 50) FROM winkels
> >
> > Most of the times I get the message
> >
> > “ERROR: Tolerance not defined
> >
> > A few times it did work and gave me a result, but trying again will
> lead to
> > the same error.
> >
> > I’m working with postgis 2.2.2dev (but also tried it with 2.2.0).

New description:

 The size of the {{{pgis_abs}}} type was changed from 8 bytes to 16 bytes
 in 2.2.0.  It doesn't appear that the upgrade procedure handles this, so
 if you upgrade to 2.2.x from a previous version, Postgres would still
 think the size is 8 bytes.

 I haven't been able to show this, because I can't actually perform an
 upgrade from 2.1.x to more recent versions due to #3429.  But this seems
 like it would explain the following issue reported to postgis-users:


 On Wed, Feb 17, 2016 at 01:44:54PM +0100, Ronnie Lassche wrote:
 > I’m trying to use the new st_clusterwithin function, but it keeps
 failing.
 >
 > I’ve tried to cluster 20 points with the following query.
 >
 > SELECT ST_ClusterWithin(geom, 50) FROM winkels
 >
 > Most of the times I get the message
 >
 > “ERROR: Tolerance not defined
 >
 > A few times it did work and gave me a result, but trying again will lead
 to
 > the same error.
 >
 > I’m working with postgis 2.2.2dev (but also tried it with 2.2.0).


 (The tolerance value is stored in the second 8 bytes of {{{pgis_abs}}})

--

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