Opened 14 years ago

Closed 14 years ago

#3508 closed defect (fixed)

PG: use AutoIdentifyEPSG() to avoid inserting duplicated entries in spatial_ref_sys; allow SRS with quotes to be inserted

Reported by: Even Rouault Owned by: Even Rouault
Priority: normal Milestone: 1.7.2
Component: OGR_SF Version: unspecified
Severity: normal Keywords: pg srs


Two issues similar to what has been done for SQLite in ticket #3506 :

  • when creating a layer from a shapefile for example, the SRS from .prj file has no authority code, so a new entry was added in spatial_ref_sys instead of reusing the existing ones. Use AutoIdentifyEPSG() to avoid this.
  • minor: some SRS such as EPSG:26632 have quotes in the WKT string, so use escaping route to avoid issues.

Change History (1)

comment:1 by Even Rouault, 14 years ago

Resolution: fixed
Status: newclosed

Fixed in trunk (r19242) and in branches/1.7 (r19243). Test updated in r19244

Note: See TracTickets for help on using tickets.