Fwd: PGAdmin cuts sql when show rules

Adding pgadmin-support list...

---------- Forwarded message ---------
From: Мытарев Евгений <[email protected]>
Date: Wed, Aug 7, 2019 at 4:29 PM
Subject: Re: PGAdmin cuts sql when show rules
To: Khushboo Vashi <[email protected]>


Hey guys.

It is your project.

And honestly it is disgusting. I still can't get used to PGAdmin4 after
using PGAdmin3.

And right now I found that It in addition gives incorrect information that
I can't trust.

I do not have time to discover a hundreds of your maillists to find out
which is specific for this bug.

I just want you to know that there is a serious problem in your programm. I
think incorect SQL is a very serious.

If you don't interesting it, ok.

I definitely don’t need it



07.08.2019, 13:43, "Khushboo Vashi" <[email protected]>:

Hi,

On Wed, Aug 7, 2019 at 4:08 PM Мытарев Евгений <[email protected]> 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;