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

[Brian Fitzgerald]

Well if I leave the -F and -I in, I get the following error when I run the
.sql:

psql:979801mosaic.sql:2: ERROR:  relation "testmosaic" already exists.

Here is what I ran:

rcgeoadmin at 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
Processing 1/1: /home/rcgeoadmin/temp/979903.tif
rcgeoadmin at 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
Processing 1/1: /home/rcgeoadmin/temp/979801.tif





On Mon, Sep 10, 2012 at 2:22 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

> 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
> > ---------------------------------------
>
> _______________________________________________
> 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
---------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120911/f02478fa/attachment.html>