[postgis-devel] Unknown coord_dimension in geometry_columns

Sandro Santilli strk at keybit.net
Tue Mar 3 06:46:16 PST 2015


As discussed in http://trac.osgeo.org/postgis/ticket/3068
I'm annoyed by the "coord_dimension" field in geometry_column arbitrarily
containing a value of 2 when the actual coordinate dimension
is unconstrained.

We do have GEOMETRY for the unconstrained "type" field and 0 for
the unconstrained "srid" field, but no equivalent "unconstrained"
for dimension.

The consequence of this is that clients cannot trust the value of
"coord_dimension" when it is 2, as that does not mean they cannot
find a geometry with higher dimension in the corresponding table.

What would you think about having a NULL value there for
unconstrained dimensions ? Or a zero for a special-meaning value ?
Or 4, for "max coordinate dimension" ?

I think NULL would make the most sense...

--strk; 



More information about the postgis-devel mailing list