I agree you Nicolas ! Are you sure the projection of your raster is SRID 2273 ? Regarding the first error, it seems to me you have a projection problem (but I am not really familiar with this kind of "extent" error)
Hugues.
-------- Message d'origine--------
De: postgis-users-boun...@postgis.refractions.net de la part de Brian Fitzgerald
Date: mar. 11/09/2012 19:10
À: PostGIS Users Discussion
Objet : 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
---------------------------------------
<<winmail.dat>>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
