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: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Chris English > Sent: Thursday, July 07, 2011 3:46 PM > To: [email protected] > 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
