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