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 > Mobile: +39-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
