#1596 closed defect (fixed)
UpdateGeometryColumn allows invalid SRIDs
| Reported by: | mwtoews | Owned by: | strk |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 1.5.4 |
| Component: | postgis | Version: | master |
| Keywords: | history | Cc: |
Description
As hinted from #1594, you can AddGeometryColumn with an unknown SRID, then use UpdateGeometrySRID to sneak in an invalid SRID — one that is not in spatial_ref_sys:
-- All good
create table a (gid serial primary key);
select AddGeometryColumn('a', 'geom', -1, 'POINT', 2);
-- Shouldn't happen
select UpdateGeometrySRID('a', 'geom', 123456);
Attachments (2)
Change History (6)
by , 13 years ago
| Attachment: | invalid_srid-1.5.patch added |
|---|
comment:1 by , 13 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:3 by , 13 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Committed in 1.5 with testcase as r9254
comment:4 by , 13 years ago
| Keywords: | history added |
|---|---|
| Milestone: | PostGIS 2.0.0 → PostGIS 1.5.4 |
Note:
See TracTickets
for help on using tickets.
patch for 1.5 branch