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

Mateusz Loskot mateusz at loskot.net
Tue Feb 26 08:41:36 PST 2013


On 26 February 2013 15:32, Bborie Park <dustymugs at gmail.com> wrote:
>
> 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
>
> I wonder if this is the expected behavior in PostgreSQL.

Bborie,

Yes, this is expected behaviour (confirmed with Sir depesz at PostgreSQL)
I've solved that problem by ensuring name of constraint is
table-and-column unique.

Here is patch:

http://trac.osgeo.org/postgis/attachment/ticket/2215/fix_2215_make_spatially_unique_constraint_name_unique.patch

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net



More information about the postgis-devel mailing list