Opened 7 years ago

Closed 6 years ago

#1219 closed defect (fixed)

Unexpected typmod in points loaded via shp2pgsql

Reported by: strk Owned by: mcayland
Priority: medium Milestone: PostGIS 2.0.0
Component: loader/dumper Version: trunk
Keywords: Cc:

Description

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.

Change History (3)

comment:1 Changed 7 years ago by 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

comment:2 Changed 6 years ago by strk

Component: postgisloader/dumper
Owner: changed from pramsey to mcayland

comment:3 Changed 6 years ago by strk

Resolution: fixed
Status: newclosed

Everything works fine as of r8710 not sure fixed when

Note: See TracTickets for help on using tickets.