Re: PGAdmin cuts sql when show rules

Hi,

On Wed, Aug 7, 2019 at 4:08 PM Мытарев Евгений <evmytarev(at)yandex(dot)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;
>
>
>
>
>
>
>
>