PGAdmin cuts sql when show rules - Mailing list pgadmin-support

From Мытарев Евгений
Subject PGAdmin cuts sql when show rules
Date
Msg-id 2223291565174323@iva6-22e79380f52c.qloud-c.yandex.net
Whole thread Raw
Responses Re: PGAdmin cuts sql when show rules  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
List 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 by date:

Previous
From: Dave Page
Date:
Subject: Re: import upload file to pgadmin get CSRF error
Next
From: Khushboo Vashi
Date:
Subject: Re: PGAdmin cuts sql when show rules