Thread: PGAdmin cuts sql when show rules
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;
Hi,
On Wed, Aug 7, 2019 at 4:08 PM Мытарев Евгений <evmytarev@yandex.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;
Adding pgadmin-support list...
---------- Forwarded message ---------
From: Мытарев Евгений <evmytarev@yandex.ru>
Date: Wed, Aug 7, 2019 at 4:29 PM
Subject: Re: PGAdmin cuts sql when show rules
To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
From: Мытарев Евгений <evmytarev@yandex.ru>
Date: Wed, Aug 7, 2019 at 4:29 PM
Subject: Re: PGAdmin cuts sql when show rules
To: Khushboo Vashi <khushboo.vashi@enterprisedb.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
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.vashi@enterprisedb.com>:
Hi,On Wed, Aug 7, 2019 at 4:08 PM Мытарев Евгений <evmytarev@yandex.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,KhushbooMy 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;