Opened 9 years ago

Closed 3 years ago

Last modified 3 years ago

#3192 closed enhancement (fixed)

Automatically convert SRID<0 to SRID=0 in topology.topology

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
Keywords: Cc:

Description

I just found that the topology built by the testsuite (load_topology.sql) succeeds in writing a -1 value in topology.topology.srid field.

This, in turn, can confuse clients: http://hub.qgis.org/issues/12802

As we gently convert -1 to 0 in other cases, I think it would be nice to do it also in the topology.topology.srid case.

Since people might already have -1's in their db, part of this would be converting existing values, updating the table.

Change History (4)

comment:1 by strk, 9 years ago

Milestone: PostGIS 2.2.0PostGIS Future
Priority: highmedium
Type: defectenhancement

comment:2 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

comment:3 by Sandro Santilli <strk@…>, 3 years ago

Resolution: fixed
Status: newclosed

In e5054a9/git:

Update topology.topology srids < 0 on upgrade

Closes #3192

comment:4 by strk, 3 years ago

For the record: [fba0330289c7ad2ed3cc5642f259940c59beda6b/git] made CreateTopology convert SRID<0 to 0

Note: See TracTickets for help on using tickets.