[postgis-tickets] [PostGIS] #2359: raster2pgsql - large collection of examples of different bugs in -l (overviews)

[PostGIS]

#2359: raster2pgsql - large collection of examples of different bugs in -l
(overviews)
---------------------+------------------------------------------------------
  Reporter:  gbell   |       Owner:  dustymugs             
      Type:  defect  |      Status:  closed                
  Priority:  high    |   Milestone:  PostGIS 2.0.4         
 Component:  raster  |     Version:  2.0.x                 
Resolution:  fixed   |    Keywords:  raster2pgsql overviews
---------------------+------------------------------------------------------
Changes (by dustymugs):

  * status:  new => closed
  * resolution:  => fixed
  * milestone:  PostGIS 2.1.0 => PostGIS 2.0.4


Comment:

 Tested on the following:

 {{{
  PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
 4.7.1, 64-b
 it | POSTGIS="2.0.4SVN r11536" GEOS="3.4.0dev-CAPI-1.8.0 r3808" PROJ="Rel.
 4.8.0
 , 6 March 2012" GDAL="GDAL 1.11dev, released 2013/04/13" LIBXML="2.8.0"
 LIBJSON=
 "UNKNOWN" RASTER
 }}}

 Item 0c: runs as expected. I get the appropriate error message from the
 database indicating that the table already exists. raster2pgsql never
 connects (and can't connect) to the database so it has no idea if the
 table already exists.

 {{{
 root at slack64:/home/software/geo/raster# raster2pgsql -t 100x100 -I -C -M
 -Y bogota.tif bogota | psql -d test
 Processing 1/1: bogota.tif
 BEGIN
 NOTICE:  CREATE TABLE will create implicit sequence "bogota_rid_seq1" for
 serial column "bogota.rid"
 ERROR:  relation "bogota" already exists
 ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 invalid command \.
 ERROR:  syntax error at or near "01000001000000000000004E400000000000004"
 LINE 1: 01000001000000000000004E400000000000004EC00000000040E61A4100...
         ^
 ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 ROLLBACK
 VACUUM
 }}}

 Item 1: Bug confirmed in schema name of overview. Fixed in r11543 for 2.0
 and r11544 for -trunk

 Item 2: Same bug as Item 1

 Item 3: Same bug as Item 1

 Item 4: Same bug as Item 1

 Item 5: Same bug as Item 1

 Item 6: Same bug as Item 1

 Item 7: I don't get any glibc issues, just the expected

 {{{
 ERROR:  relation "bogota" already exists
 }}}

 Item 8: description does not match code so assuming scale of 2 for first
 call to raster2pgsql. If table isn't dropped between the two calls,
 expected error of ration existing returned. If table is dropped between
 calls, no problems as same bug as Item 1.

 Item 9: Same bug as Item 1

 Items 10 - 12: Same bug as Item 1

 Item 13: As expected as all scale factors are treated as integers

 Item 14: Not misleading as the value after -l is considered the scale
 value. So, error is correct.

 Item 15: 100 billion can't be stored in an int but the error message is
 correct.

 Item 16: Same bug as Item 1

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