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

PostGIS trac at osgeo.org
Tue Dec 27 17:32:44 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:               
-----------------------------+----------------------------------------------

Comment(by dustymugs):

 Yes.  You are correct.  Something is up with the INSERT version.  Unlike
 the COPY version that has no issues, the INSERT version has constraint
 issues.

 I'm using the following:

 COPY
 {{{
 raster2pgsql -I -e -C -F -Y -s 26986 -t 200x200 -l 2 23128870.sid.jpg
 boston_test7 > copy.sql
 }}}

 INSERT
 {{{
 raster2pgsql -I -e -C -F -s 26986 -t 200x200 -l 2 23128870.sid.jpg
 boston_test8 > insert.sql
 }}}

 BUT if I remove the overview switch from the INSERT statements loader, the
 constraint errors go away.

 I'll do some debugging.

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