[postgis-devel] [PostGIS] #1404: [raster] raster2pgsql overviews don't look right

PostGIS trac at osgeo.org
Tue Dec 27 06:40:47 PST 2011


#1404: [raster] raster2pgsql overviews don't look right
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  pracine      
      Type:  defect          |      Status:  reopened     
  Priority:  medium          |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------
Changes (by robe):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 Okay I think after much head scratching, flipping binaries, renaming
 binaries, restarting servers, going back and forth the answer is is as
 they say "The most probable one". It has something to do with the order of
 the args or args used.

 I realized that when I cut and pasted from this ticket, things worked, but
 yet my script did not so I must have made a transcription error.  After
 isolating all the switches I was using,

 I realized my script was not using the -Y option.  Can you test on yours?

 good
 {{{

 raster2pgsql -I -e -C -F -Y -s 26986 -t 200x200 -l 2 23128870.sid.jpg
 boston_test7 | psql
 }}}

 bad

 {{{
 raster2pgsql -I -e -F -C -s 26986 -t 200x200 -l 2 23128870.sid.jpg
 boston_test8 | psql
 }}}

 I was fiddling with the order of args as well, but I concluded that that
 didn't seem to make a difference.

 I'm reopening this ticket since I think there is something wrong, but not
 quite sure what.

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