[postgis-devel] [PostGIS] #1708: postgis_restore not converting ndims and srid constraints to st_...

PostGIS trac at osgeo.org
Thu Apr 12 03:44:05 PDT 2012


#1708: postgis_restore not converting ndims and srid constraints to st_...
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  strk         
     Type:  defect                 |      Status:  assigned     
 Priority:  medium                 |   Milestone:  PostGIS 2.0.1
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Comment(by strk):

 Confirmed for ndims, not for st_srid.
 Could you please write the output from postgis_restore.pl into a file and
 then grep CHECK in it ?

 My output:
 {{{
 $ grep CHECK backup.sql
     CONSTRAINT enforce_dims_the_geom CHECK ((ndims(the_geom) = 2)),
     CONSTRAINT enforce_geotype_the_geom CHECK (((geometrytype(the_geom) =
 'MULTIPOLYGON'::text) OR (the_geom IS NULL))),
     CONSTRAINT enforce_srid_the_geom CHECK ((st_srid(the_geom) = 2249))
 ]}}

 You can see "enforce_srid_the_geom" CHECK was correctly rewritten

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1708#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list