Unexpected typmod in points loaded via shp2pgsql

[strk]

I've done: shp2pgsql linea.shp linea | psql

In the resulting table, shown with \d, the geometry columns is:

 geom       | geometry(Point,2097151) | 

Shouldn't it have an unknown SRID (0 or -1, dunno) ? For sure there's no such thing as that srid in spatial_ref_sys…

ST_SRID(geom) returns -1 for all entries.

[robe]

Yah I noticed this myself. It's because we don't have anyway of representing -1 but figured that was still on the todo so was going to press the point later.

BTW there is no way for me to get SRID 0 back though I desperately want it even if I explicitly ask for 0.

e.g.

CREATE TABLE testpit(pit geometry(Point,0))

INSERT INTO testpit(pit)
SELECT ST_SetSRID(ST_Point(1,0),0);

SELECT ST_SRID(pit) FROM testpit;
--result --
-1

[strk]

Everything works fine as of r8710 not sure fixed when