Opened 9 years ago
Last modified 9 years ago
#3460 closed defect
Upgrade to 2.2 doesn't adjust size of pgis_abs type — at Version 1
Reported by: | dbaston | Owned by: | pramsey |
---|---|---|---|
Priority: | high | Milestone: | PostGIS 2.2.2 |
Component: | postgis | Version: | 2.2.x |
Keywords: | Cc: |
Description (last modified by )
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
)