Ticket #1175 (closed defect: fixed)
AddRasterColumn is broken
|Reported by:||robe||Owned by:||pracine|
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.