Hi, On Wed, Aug 7, 2019 at 4:08 PM Мытарев Евгений <evmyta...@yandex.ru> wrote:
> Hi, > > I have a bug in 4.11. It show rules sql incorrect. > > > Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4 . Thanks, Khushboo > 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 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; > > > > 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; > > > > > > > >
