Put the -C option just in the last command. If you put it in the first, the max extent constraint prevent the table from accepting more tiles (unless you put -C with -x).
Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Brian Fitzgerald > Sent: Tuesday, September 11, 2012 1:10 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] PostGIS 2.0 Raster Mosaic... > > I just tried the following (following your example) and get the following > error: > > ./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif > public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql > > psql -d mydb -f 979801mosaic.sql > > ./raster2pgsql -a -s 2273 -t 256x256 -M -F /home/rcgeoadmin/temp/979903.tif > public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql > > psql -d mydb -f 979903mosaic.sql > > > ERROR: > > postgres@minty /home/rcgeoadmin/temp $ psql -d mydb -f 979903mosaic.sql > BEGIN > psql:979903mosaic.sql:2: ERROR: new row for relation "testmosaic" violates > check constraint "enforce_max_extent_rast" > psql:979903mosaic.sql:3: ERROR: current transaction is aborted, commands > ignored until end of transaction block > psql:979903mosaic.sql:4: ERROR: current transaction is aborted, commands > ignored until end of transaction block > ..... > > > > On Tue, Sep 11, 2012 at 12:57 PM, Markus Innerebner > <markus.innereb...@inf.unibz.it> wrote: > > > I am doing the same thing with success: > > use my script: > > cheers Markus > > ************* > param 1: name the directory in which the files are located > param2: name of the table in which the files are loaded > ************* > more raster2pgHydroalp.sh > #!/bin/bash > # this script imports raster ascii file into postgis > # > isFirst=true; > cd $1; > > for i in $(\ls *.asc); > do > echo $i > if $isFirst > then > raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d > hydroalp'; > isFirst=false > else > raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d > hydroalp' > fi > done > > cd .. > > *********** > > > > -- > Ph D. Student Markus Innerebner > > DIS Research Group - Faculty of Computer Science > Free University Bozen-Bolzano > > Dominikanerplatz 3 - Room 211 > I - 39100 Bozen > Phone: +39-0471-016143 <tel:%2B39-0471-016143> > Mobile: +39-333-9392929 <tel:%2B39-333-9392929> > > > gpg --fingerprint > ------------------------------------- > pub 1024D/588F6308 2007-01-09 > Key fingerprint = 6948 947E CBD2 89FD E773 E863 914F EB1B 588F > 6308 > sub 2048g/BF4877D0 2007-01-09 > > > On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote: > > > 979903mosaic.sql > > > > _______________________________________________ > 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
