[postgis-devel] [PostGIS] #1175: AddRasterColumn is broken

[PostGIS]

#1175: AddRasterColumn is broken
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 I get this error when trying to install on both my 9.0 and 9.1 instances.


 {{{
 psql:share/contrib/postgis-2.0/rtpostgis.sql:3082: ERROR:  syntax error at
 or ne
 ar ","
 LINE 30:                      p_catalog_name, p_schema_name, p_table_...
 }}}


 Can't test my 8.4 unfortunately because of those outstanding compile
 issues.

 Looks like someone tried to comment out a RAISE DEBUG but didn't comment
 both lines this is line 2839 of rtpostgis.sql.in.c


 {{{
         --RAISE DEBUG 'Parameters: catalog=%, schema=%, table=%, column=%,
 srid=%, pixel_types=%, out_db=%, regular_blocking=%, nodata_values=%,
 scale_x=%, scale_y=%, blocksize_x=%, blocksize_y=%',
                      p_catalog_name, p_schema_name, p_table_name,
 p_column_name, p_srid, p_pixel_types, p_out_db, p_regular_blocking,
 p_nodata_values, p_scale_x, p_scale_y, p_blocksize_x, p_blocksize_y;
 }}}

 BTW we should probably wrap rtpostgis.sql in a transaction so these errors
 are caught earlier.  Though I suppose you can't really do that until you
 have an uninstall script.

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