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-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@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.franc...@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-boun...@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 > bkf...@gmail.com > 803.426.3469 > --------------------------------------- > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > -- > -------------------------------------- > Brian Fitzgerald, PMP, GISP > bkf...@gmail.com > 803.426.3469 > --------------------------------------- _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
