Thread: 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