PGAdmin cuts sql when show rules

From: Мытарев Евгений <evmytarev(at)yandex(dot)ru>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: PGAdmin cuts sql when show rules
Date: 2019-08-07 10:38:43
Message-ID: 2223291565174323@iva6-22e79380f52c.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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;

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2019-08-07 10:43:17 Re: PGAdmin cuts sql when show rules
Previous Message Dave Page 2019-08-07 10:19:43 Re: import upload file to pgadmin get CSRF error