I just tried the following (following your example) and get the following error:<div><br></div><div><div>./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql</div>
<div><br></div><div>psql -d mydb -f 979801mosaic.sql</div><div><br></div><div><div>./raster2pgsql -a -s 2273 -t 256x256 -M -F /home/rcgeoadmin/temp/979903.tif public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql</div>
</div><div><br></div><div>psql -d mydb -f 979903mosaic.sql</div><div><br></div><div><br></div><div>ERROR:</div><div><br></div><div><div>postgres@minty /home/rcgeoadmin/temp $ psql -d mydb -f 979903mosaic.sql </div><div>BEGIN</div>
<div>psql:979903mosaic.sql:2: ERROR: new row for relation "testmosaic" violates check constraint "enforce_max_extent_rast"</div><div>psql:979903mosaic.sql:3: ERROR: current transaction is aborted, commands ignored until end of transaction block</div>
<div>psql:979903mosaic.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block</div></div><div>.....</div><div><br></div><div><br></div><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 12:57 PM, Markus Innerebner <span dir="ltr"><<a href="mailto:markus.innerebner@inf.unibz.it" target="_blank">markus.innerebner@inf.unibz.it</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>I am doing the same thing with success:</div><div><br></div><div>use my script:</div>
<div><br></div><div>cheers Markus</div><div><br></div><div>*************</div><div>param 1: name the directory in which the files are located</div><div>param2: name of the table in which the files are loaded</div><div>*************</div>
<div>more raster2pgHydroalp.sh </div><div><div>#!/bin/bash</div><div># this script imports raster ascii file into postgis</div><div># </div><div>isFirst=true;</div><div>cd $1;</div><div><br></div><div>for i in $(\ls *.asc); </div>
<div> do</div><div> echo $i </div><div> if $isFirst </div><div> then </div><div> raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d hydroalp';</div><div> isFirst=false</div><div> else </div>
<div> raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d hydroalp'</div><div> fi</div><div>done</div><div><br></div><div>cd ..</div></div><div><br></div><div>***********</div><div><br></div>
<div>
<br></div><br><div>
<div>-- <br>Ph D. Student Markus Innerebner<br><br>DIS Research Group - Faculty of Computer Science<br>Free University Bozen-Bolzano<br><br>Dominikanerplatz 3 - Room 211<br>I - 39100 Bozen<br>Phone: <a href="tel:%2B39-0471-016143" value="+390471016143" target="_blank">+39-0471-016143</a><br>
Mobile: <a href="tel:%2B39-333-9392929" value="+393339392929" target="_blank">+39-333-9392929</a><br><br><br>gpg --fingerprint<br>-------------------------------------<br>pub 1024D/588F6308 2007-01-09<br> Key fingerprint = 6948 947E CBD2 89FD E773 E863 914F EB1B 588F 6308<br>
sub 2048g/BF4877D0 2007-01-09<br></div>
</div>
<br><div><div>On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:</div><br><blockquote type="cite"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium">979903mosaic.sql</span></blockquote>
</div><br></div><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></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>