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;