Ticket #1596 (closed defect: fixed)
UpdateGeometryColumn allows invalid SRIDs
| Reported by: | mwtoews | Owned by: | strk |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 1.5.4 |
| Component: | postgis | Version: | trunk |
| 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
-
invalid_srid-1.5.patch
(1.0 KB) - added by mwtoews
15 months ago.
- patch for 1.5 branch
-
invalid_srid-2.0.patch
(2.0 KB) - added by mwtoews
15 months ago.
- patch for trunk
Change History
Note: See
TracTickets for help on using
tickets.
