[postgis-users] RE : PostGIS 2.0 Raster Mosaic...

[Pierre Racine]

Why did you remove the -F option in the second command? You're trying to append less columns in an existing table.

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Brian Fitzgerald
> Sent: Monday, September 10, 2012 1:13 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] RE : PostGIS 2.0 Raster Mosaic...
> 
> Here is what I tried without luck:
> 
> Step 1 : ./raster2pgsql -s 2273 -t 256x256 -F -I
> /home/rcgeoadmin/temp/979903.tif public.testmosaic >
> /home/rcgeoadmin/temp/979903mosaic.sql
> Step 2:  psql -d mydb -f 979903mosaic.sql
> Step 3:  ./raster2pgsql -s 2273 -t 256x256 -a
> /home/rcgeoadmin/temp/979801.tif public.testmosaic >
> /home/rcgeoadmin/temp/979801mosaic.sql
> Step 4:  psql -d mydb -f 979801mosaic.sql
> 
> 
> 
> 
> 
> On Mon, Sep 10, 2012 at 12:02 PM, Francois Hugues
> <hugues.francois at irstea.fr> wrote:
> 
> 
> 	I may be wrong but I think the problem comes from the index. You use
> the option -I to create it but you cannot create it more than once. You should
> just remove the -I option from the second time you use your command and I
> think it should work.
> 
> 	Hugues.
> 
> 
> 	-------- Message d'origine--------
> 	De: postgis-users-bounces at postgis.refractions.net de la part de Brian
> Fitzgerald
> 	Date: lun. 10/09/2012 17:57
> 	À: PostGIS Users Discussion
> 	Objet : [postgis-users] PostGIS 2.0 Raster Mosaic...
> 
> 	... trying to create a raster mosaic using the raster2pgsql tool... I
> 	imported a tif image and now I want to append a second adjacent tiff to
> the
> 	first one... figured I could just run the same command with -F -I -t
> 	256x256 etc and tack on the -a?  I tried this and got an error saying:
> 
> 	'testmosaic_raster_gist' already exists... anyone know how to
> accomplish
> 	this?
> 
> 	- Brian
> 
> 	--
> 	--------------------------------------
> 	Brian Fitzgerald, PMP, GISP
> 	bkfitz at gmail.com
> 	803.426.3469
> 	---------------------------------------
> 
> 
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at postgis.refractions.net
> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> 
> 
> --
> --------------------------------------
> Brian Fitzgerald, PMP, GISP
> bkfitz at gmail.com
> 803.426.3469
> ---------------------------------------