Disable View rule

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs