[postgis-users] ST_AddBand syntax

[Pierre Racine]

Which version are you using? There has been some tickets about this problem and they should be fixed at the tip of the trunk. They were mostly with 64BF however...

In the second syntax I think you have to cast '32BUI' to text like this:

ST_AddBand(rast,'32BUI'::text, 1);

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Chris English
> Sent: Thursday, July 07, 2011 3:46 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] ST_AddBand syntax
> 
> Hi,
> 
> I have a raster table of 336 tiles.  I want to add a raster band (4) to the table.
> 
> UPDATE redbike
> SET rast = ST_AddBand(rast,4,'32BUI');
> 
> ********** Error **********
> ERROR: syntax error at or near "("
> 
> A variant on the above:
> 
> UPDATE redbike
> SET rast = ST_AddBand(rast,'32BUI', 1);
> 
> ********** Error **********
> 
> no connection to the server
> 
> At which point a reboot is required to get server back.
> 
> So, that's the goal, at a 4th band to a raster that currently has 3
> 
> Thnks,
> Chris
> 
> --
> doesn't fully understand what he thinks he knows about the problem.