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

[Mateusz Loskot]

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