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!
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 |