Обсуждение: Disable View rule

Hi
I am Silambarasan. could you help me, How to disable the View rule.

Example:
We disable Trigger constraint like
update pg_trigger set tgenabled=3D'D'

I request to disable View rule.

Thanks & Regards
Silambarasan Viswanathan MTT

Hello, Silambarasan.

You wrote:


SV> Hi
SV> I am Silambarasan. could you help me, How to disable the View rule.
SV>
SV> Example:
SV> We disable Trigger constraint like
SV> update pg_trigger set tgenabled='D'
SV>
SV> I request to disable View rule.
SV>
SV> Thanks & Regards
SV> Silambarasan Viswanathan MTT

ALTER TABLE view_name DISABLE RULE rewrite_rule_name;

--
With best wishes,
 Pavel                          mailto:pavel@gf.microolap.com

Pavel Golub <pavel@microolap.com> writes:
> You wrote:
> SV> I am Silambarasan. could you help me, How to disable the View rule.

> ALTER TABLE view_name DISABLE RULE rewrite_rule_name;

The code won't let you do that; but I wonder what the OP thinks would
happen if it did.  A view doesn't have any underlying storage that could
be selected from if the on-select rule were to go away.

            regards, tom lane