From: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Fwd: PGAdmin cuts sql when show rules |
Date: | 2019-08-07 11:02:33 |
Message-ID: | CAFOhELdmupHpfE8MoZpG-ANbV14MpMLSARdPghxqb=PjJKdA6A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Adding pgadmin-support list...
---------- Forwarded message ---------
From: Мытарев Евгений <evmytarev(at)yandex(dot)ru>
Date: Wed, Aug 7, 2019 at 4:29 PM
Subject: Re: PGAdmin cuts sql when show rules
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
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" <khushboo(dot)vashi(at)enterprisedb(dot)com>:
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2019-08-07 11:31:02 | Re: import upload file to pgadmin get CSRF error |
Previous Message | Wh isere | 2019-08-07 11:01:16 | Re: import upload file to pgadmin get CSRF error |