Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] PostgreSQL 10 changes in exclusion constraints - did something change? - Mailing list pgsql-hackers

From Regina Obe
Subject [HACKERS] PostgreSQL 10 changes in exclusion constraints - did something change?
Date
Msg-id 000901d2d598$211d2870$63577950$@pcorp.us
Whole thread Raw
List pgsql-hackers
Tree view 
Did something change with how exclusion constraints are handled?  I'm trying
to troubleshoot a regression we are having with PostGIS raster support.

As best I can guess, it's because exclusion constraints that used to work in
past versions are failing in PostgreSQL 10 with an error something like
this:

ERROR:  conflicting key value violates exclusion constraint
"enforce_spatially_unique_test_raster_columns_rast"
ERROR:  new row for relation "test_raster_columns" violates check constraint
"enforce_coverage_tile_rast"

Unfortunately I don't know how long this has been an issue since we had an
earlier test failing preventing the raster ones  from being tested.

Thanks,
Regina

pgsql-hackers by date:

Previous
From: Jeevan Ladhe
Date:
Subject: [HACKERS] fix side-effect in get_qual_for_list()
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.