hubert depesz lubaczewski <dep...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
