Re: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait
От кого: "Andres Freund" <andres@anarazel.de>
This is the reason the lack of detailed description of the problems discussed in "bug".
Maybe it's not a bug in the truest sense.
There is a process:In the empty base creates the necessary data structure.
Then, based on the contents of the tables "pg_catalog" obtain and maintain the description of this structure (snapshot).
In the future, comparing the (snapshot) with another (snapshot) received from the production database, a decision about the difference between the structures and the need to transform the production database.
The essence of the problem :
Developer creates check constrait according to [1] describe the bug.
In reference (snapshot) to store the result of [1] describe the bug.
Add instruction is generated from the reference (snapshot) and corresponds to [2] describe the bug.
Дата: 11 февраля 2016, 01:56:06
Hi, just sorry for my english, it's Google translator.On 2016-02-10 10:53:28 +0000, gsv371@ukr.net wrote: > 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! Why do you consider that a bug? Regards, Andres
This is the reason the lack of detailed description of the problems discussed in "bug".
Maybe it's not a bug in the truest sense.
There is a process:
Then, based on the contents of the tables "pg_catalog" obtain and maintain the description of this structure (snapshot).
In the future, comparing the (snapshot) with another (snapshot) received from the production database, a decision about the difference between the structures and the need to transform the production database.
The essence of the problem :
Developer creates check constrait according to [1] describe the bug.
In reference (snapshot) to store the result of [1] describe the bug.
The production database is missing the check constraint and the decision of its creation.
Add instruction is generated from the reference (snapshot) and corresponds to [2] describe the bug.
After this addition, we obtain check constrait which is functionally equivalent to the reference, but differs from the description of the reference.
And this in turn causes a re-creation check constrait for each of the subsequent verification of the production database structure.
Thank you and best regards.
Sergiy Gavrylenko.
Thank you and best regards.
Sergiy Gavrylenko.
В списке pgsql-bugs по дате отправления: