[postgis-devel] Gserialized Enabled vs Disabled

Paragon Corporation lr at pcorp.us
Thu Dec 30 22:06:36 PST 2010


I'm seeing a bunch of differences when doing a regress compare between these
two 

Mostly with the way they handle empty geometries and the newer types like
TIN.

It's almost as if the serialized is not doing any short-circuiting and the
non-serialized is.

For example:

1)  SELECT ST_Disjoint(ST_GeomFromEWKT('SRID=4326;POINT(-11.1111111 40)'),
ST_GeomFromEWKT('SRID=4326;TRIANGLE((-71.0821 42.3036,-71.0821
42.3936,-71.0901 42.3036,-71.0821 42.3036))'))


In the regular case - non-gserialized:
This returns: t

In the gserialized -- this returns

Unknown geometry type: 14 - Triangle

So it's like the non-gserialized is smart enough to realize that if the
bounding box does not intersect there is no need to jump into geos or do
anything further analysis - it knows they are disjoint.

I'm seeing a lot of these silly failures.  Which are perhaps by design.

Thanks,
Regina





More information about the postgis-devel mailing list