Re: Drop or disable or bypass "_return" rule on select on a view.

On Thu, May 28, 2015 at 8:23 AM, Shashwat Arghode
<shashwatarghode(at)gmail(dot)com> wrote:
> Hi all,
> I am using postgres 9.3.4 and have an on_select rule "_return" on a view.
> I want to drop or disable or bypass that rule.
> Is there any way it can be done without dropping the view??
>
> Because when i try to drop it, it returns
>
> ERROR: cannot drop rule _RETURN on view viewname because view viewname
> requires it
> HINT: You can drop viewname instead.
> CONTEXT: SQL statement "drop rule "_RETURN" on viewname"
> PL/pgSQL function inline_code_block line 12 at EXECUTE statement

I suspect you have messed up names, creating the rule on the target
table instead of another one used as a placeholder.
See the example here:
http://www.postgresql.org/docs/current/static/rules-views.html

Luca