[postgis-devel] [PostGIS] #1373: Can't apply Scale Y constraint -- raster2pgsql

[PostGIS]

#1373: Can't apply Scale Y constraint -- raster2pgsql
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I think so.  I suspect a lot of spatial data is going to have scales that
 are way out there but are just a result of flaot error accumulation.
 Especially if they were transformed from another projection.  My table
 does have all the same scale.

 I think the best solution is just convert it to numeric in check
 constraint to a reasonable level of precision.  Say numeric(16,10).
 Beyond that I would say any extra digits are junk.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1373#comment:7>
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.