Re: Disable View rule - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Disable View rule
Date
Msg-id 26068.1405520759@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disable View rule  (Pavel Golub <pavel@microolap.com>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter
Next
From: Tom Lane
Date:
Subject: Re: SQLSTATE 00000 and message level LOG get logged when a server process crashes