Opened 13 years ago

Closed 13 years ago

#1175 closed defect (fixed)

AddRasterColumn is broken

Reported by: robe Owned by: pracine
Priority: blocker Milestone: PostGIS 2.0.0
Component: raster Version: master
Keywords: Cc:

Description

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.

Change History (1)

comment:1 by dustymugs, 13 years ago

Resolution: fixed
Status: newclosed

Oops. That would be my fault. Fixed in r7791.

Note: See TracTickets for help on using tickets.