[postgis-devel] [raster] Testing out-db and regular blocking

dustymugs dustymugs at gmail.com
Tue Feb 26 07:44:00 PST 2013


Please do open a ticket.  I need to see what are our options.

Thanks!

-bborie
-----Original Message-----
From: Mateusz Loskot <mateusz at loskot.net>
Sender: postgis-devel-bounces at lists.osgeo.org
Date: Tue, 26 Feb 2013 15:39:34 
To: PostGIS Development Discussion<postgis-devel at lists.osgeo.org>
Reply-To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Subject: Re: [postgis-devel] [raster] Testing out-db and regular blocking

On 26 February 2013 15:32, Bborie Park <dustymugs at gmail.com> wrote:
> Ah.  I see what might be going on.  It looks like there's an error
> creating the implicit exclusion index for the
> enforce_spatially_unique_rast constraint.  It looks like postgres
> tries to create the exclusion index with the same name as the
> constraint, but fails as it already exists...
>
> NOTICE:  ALTER TABLE / ADD EXCLUDE will create implicit index
> "enforce_spatially_unique_rast" for table "indb"
> ...
> NOTICE:  Returned error message: relation
> "enforce_spatially_unique_rast" already exists
>
> Confirmed using a simplified test case.  I wonder if this is the
> expected behavior in PostgreSQL.
>
> {{{
> CREATE TABLE foo AS
>         SELECT
>                 id
>         FROM generate_series(1, 5) t(id);
> CREATE TABLE bar AS
>         SELECT
>                 id
>         FROM generate_series(1, 5) t(id);
> ALTER TABLE foo
>         ADD CONSTRAINT enforce_unique_id EXCLUDE (id WITH =);
> ALTER TABLE bar
>         ADD CONSTRAINT enforce_unique_id EXCLUDE (id WITH =);
> }}}

Bborie,

Yes, it looks you've pinned down the problem:

$ raster2pgsql -R -C -r  /home/mloskot/data/geotiff/world.tif t1 > t1.sql
$ psql -d rasters2 -f t1.sql

psql:t1.sql:4: NOTICE:  ALTER TABLE / ADD EXCLUDE will create implicit
index "enforce_spatially_unique_rast" for table "t1"

psql:t1.sql:4: NOTICE:  Unable to add constraint: enforce_spatially_unique_rast

psql:t1.sql:4: NOTICE:  SQL used for failed constraint: ALTER TABLE
public.t1 ADD CONSTRAINT enforce_spatially_unique_rast EXCLUDE
((rast::geometry) WITH =)

psql:t1.sql:4: NOTICE:  Returned error message: relation
"enforce_spatially_unique_rast" already exists

Shall I open a ticket?

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel


More information about the postgis-devel mailing list