Well if I leave the -F and -I in, I get the following error when I run the .sql:<div><br></div><div><div>psql:979801mosaic.sql:2: ERROR: relation "testmosaic" already exists.</div><div><br></div><div>Here is what I ran:</div>
<div><br></div><div><div>rcgeoadmin@minty ~/src/postgis-2.0.1/raster/loader $ ./raster2pgsql -s 2273 -t 256x256 -F -I /home/rcgeoadmin/temp/979903.tif public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql</div><div>
Processing 1/1: /home/rcgeoadmin/temp/979903.tif</div><div>rcgeoadmin@minty ~/src/postgis-2.0.1/raster/loader $ ./raster2pgsql -s 2273 -t 256x256 -F -I /home/rcgeoadmin/temp/979801.tif public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql</div>
<div>Processing 1/1: /home/rcgeoadmin/temp/979801.tif</div></div><div><br></div><div><br></div><div><br></div><div><br></div><br><div class="gmail_quote">On Mon, Sep 10, 2012 at 2:22 PM, Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca" target="_blank">Pierre.Racine@sbf.ulaval.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Why did you remove the -F option in the second command? You're trying to append less columns in an existing table.<br>
<div class="HOEnZb"><div class="h5"><br>
> -----Original Message-----<br>
> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> [mailto:<a href="mailto:postgis-users-">postgis-users-</a><br>
> <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of Brian Fitzgerald<br>
> Sent: Monday, September 10, 2012 1:13 PM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] RE : PostGIS 2.0 Raster Mosaic...<br>
><br>
> Here is what I tried without luck:<br>
><br>
> Step 1 : ./raster2pgsql -s 2273 -t 256x256 -F -I<br>
> /home/rcgeoadmin/temp/979903.tif public.testmosaic ><br>
> /home/rcgeoadmin/temp/979903mosaic.sql<br>
> Step 2: psql -d mydb -f 979903mosaic.sql<br>
> Step 3: ./raster2pgsql -s 2273 -t 256x256 -a<br>
> /home/rcgeoadmin/temp/979801.tif public.testmosaic ><br>
> /home/rcgeoadmin/temp/979801mosaic.sql<br>
> Step 4: psql -d mydb -f 979801mosaic.sql<br>
><br>
><br>
><br>
><br>
><br>
> On Mon, Sep 10, 2012 at 12:02 PM, Francois Hugues<br>
> <<a href="mailto:hugues.francois@irstea.fr">hugues.francois@irstea.fr</a>> wrote:<br>
><br>
><br>
> I may be wrong but I think the problem comes from the index. You use<br>
> the option -I to create it but you cannot create it more than once. You should<br>
> just remove the -I option from the second time you use your command and I<br>
> think it should work.<br>
><br>
> Hugues.<br>
><br>
><br>
> -------- Message d'origine--------<br>
> De: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> de la part de Brian<br>
> Fitzgerald<br>
> Date: lun. 10/09/2012 17:57<br>
> À: PostGIS Users Discussion<br>
> Objet : [postgis-users] PostGIS 2.0 Raster Mosaic...<br>
><br>
> ... trying to create a raster mosaic using the raster2pgsql tool... I<br>
> imported a tif image and now I want to append a second adjacent tiff to<br>
> the<br>
> first one... figured I could just run the same command with -F -I -t<br>
> 256x256 etc and tack on the -a? I tried this and got an error saying:<br>
><br>
> 'testmosaic_raster_gist' already exists... anyone know how to<br>
> accomplish<br>
> this?<br>
><br>
> - Brian<br>
><br>
> --<br>
> --------------------------------------<br>
> Brian Fitzgerald, PMP, GISP<br>
> <a href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
> <a href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
> ---------------------------------------<br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
><br>
><br>
><br>
><br>
> --<br>
> --------------------------------------<br>
> Brian Fitzgerald, PMP, GISP<br>
> <a href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
> <a href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
> ---------------------------------------<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span>------------------------------</span><span>--------</span><br><span>Brian Fitzgerald, PMP, GISP</span><br><a href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span>803.426.3469</span><br><span>------------------------------</span><span>---------</span><br>
</div>