PGAdmin cuts sql when show rules
От | Мытарев Евгений |
---|---|
Тема | PGAdmin cuts sql when show rules |
Дата | |
Msg-id | 2223291565174323@iva6-22e79380f52c.qloud-c.yandex.net обсуждение исходный текст |
Ответы |
Re: PGAdmin cuts sql when show rules
|
Список | pgadmin-support |
Hi, I have a bug in 4.11. It show rules sql incorrect. My rule is CREATE OR REPLACE RULE replace_expression_answer AS ON INSERT TO dict.expression_answer WHERE (EXISTS ( SELECT 1 FROM dict.expression_answer expression_answer_1 WHERE expression_answer_1.id = new.id AND expression_answer_1.expression_id = new.expression_id)) DO INSTEAD UPDATEdict.expression_answer SET header = new.header, condition = new.condition, formula = new.formula WHERE expression_answer.id = new.id AND expression_answer.expression_id = new.expression_id; But in PGAdmin 4 I see only CREATE OR REPLACE RULE replace_expression_answer AS ON INSERT TO dict.expression_answer WHERE expression_answer_1.id = new.id AND expression_answer_1.expression_id = new.expression_id)) DO INSTEAD UPDATE dict.expression_answer SET header = new.header, condition = new.condition, formula = new.formula WHERE expression_answer.id = new.id AND expression_answer.expression_id = new.expression_id;
В списке pgadmin-support по дате отправления: