[postgis-users] table creation and mixed geometries

Sandro Santilli strk at kbt.io
Mon Jul 31 04:31:32 PDT 2017

On Fri, Jul 28, 2017 at 10:56:14PM -0400, Regina Obe wrote:

> a) geom geometry   means no restriction whatsoever.  No typmod is applied.
> b) geometry typmod is short for any 2D geometry so it won't allow Zs.

It keeps striking me that there's no way to have unconstrained number
of dimensions when using AddGeometryColumn (both typmod based or
constraint-based). We can have unconstrained spatial type and SRS but
no unconstrained ZM flags: isn't that unfair ?


More information about the postgis-users mailing list