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

[Brian Fitzgerald]

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 at 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.innerebner at 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 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/57b9ff24/attachment.html>