[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:                  |  
----------------------------+-----------------------------------------------
 Bborie,

 This may be my misunderstanding, but assuming its a bug

 I have this command


 {{{
 raster2pgsql -I -C -s 26986 -t 100x100 bostonaerials2008\*.jpg  -l 4
 aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432
 }}}


 data loads but when it gets to applying constraints -- it gives this
 error:


 {{{
 psql:bostonl4.sql:8028: NOTICE:  Unable to add constraint
 "enforce_scaley_rast"
 }}}


 I verified my scales are all the same with these statements

 {{{
 SELECT DISTINCT ST_ScaleY(rast) from aerials.boston;
 }}}


 I just get one record -0.3


 {{{
 SELECT DISTINCT ST_ScaleY(rast) from aerials.o_4_boston;
 }}}


 Gives me -1.2


 So not sure why it wouldn't be able to apply the constraints.

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