[postgis-devel] Unknown coord_dimension in geometry_columns

Paul Ramsey pramsey at cleverelephant.ca
Tue Mar 3 06:46:56 PST 2015


The other possibility with be ‘4’, indicating the ‘maximum possible’ dimension.
How do I declare an ‘unconstrained’ dimension in my CREATE TABLE statement, BTW?

P. 


--  
http://postgis.net  
http://cleverelephant.ca


On March 3, 2015 at 6:46:22 AM, Sandro Santilli (strk at keybit.net) wrote:
> 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;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>  




More information about the postgis-devel mailing list