Re: Error in exclusion constraint error message (8.5)?

hubert depesz lubaczewski <depesz@depesz.com> writes:
> 3rd insert fails (correctly), but I have doubts about its error message, which was:

> psql:z.sql:18: ERROR:  conflicting key value violates exclusion constraint "overlapping_times"
> DETAIL:  Key (box(point(date_part('epoch'::text, timezone('UTC'::text, from_ts)), date_part('epoch'::text,
timezone('UTC'::text,from_ts))), point(date_part('epoch'::text, timezone('UTC'::text, to_ts)), date_part('epoch'::text,
timezone('UTC'::text,to_ts)))))=((1232078399,1232078399),(1231387200,1231387200)) conflicts with existing key
(box(point(date_part('epoch'::text,timezone('UTC'::text, from_ts)), date_part('epoch'::text, timezone('UTC'::text,
from_ts))),point(date_part('epoch'::text, timezone('UTC'::text, to_ts)), date_part('epoch'::text, timezone('UTC'::text,
to_ts)))))=((1232078399,1232078399),(1231387200,1231387200)).

Yeah, this is a bug; and it reflects a wrong test not only a wrong error
message.  Patch applied --- thanks for the report!

            regards, tom lane