BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait

From: gsv371(at)ukr(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait
Date: 2016-02-10 10:53:28
Message-ID: 20160210105328.24150.99473@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13941
Logged by: Sergiy Gavrylenko
Email address: gsv371(at)ukr(dot)net
PostgreSQL version: 9.5.0
Operating system: Windows Vista
Description:

PostgreSQL 9.5:
1.
ALTER TABLE schedule ADD CONSTRAINT schedule_fact_quant_val CHECK
(fact_quant BETWEEN 0 AND 23.59 AND (fact_quant - trunc(fact_quant)) <
0.6);
result (pg_constraint.consrc): "(((fact_quant >= (0)::numeric) AND
(fact_quant <= 23.59)) AND ((fact_quant - trunc(fact_quant)) < 0.6))"
2.
ALTER TABLE schedule ADD CONSTRAINT schedule_fact_quant_val CHECK
(((fact_quant >= (0)::numeric) AND (fact_quant <= 23.59)) AND ((fact_quant -
trunc(fact_quant)) < 0.6));
result (pg_constraint.consrc): "((fact_quant >= (0)::numeric) AND
(fact_quant <= 23.59) AND ((fact_quant - trunc(fact_quant)) < 0.6))"
----------------------------------
PostgreSQL 9.4 - identical results!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2016-02-10 16:47:36 Re: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait
Previous Message prathameshsonavane 2016-02-10 10:46:04 BUG #13940: rollback prepared is not working