From: | Vincenzo Campanella <vinz65(at)gmail(dot)com> |
---|---|
To: | Shashwat Arghode <shashwatarghode(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Drop or disable or bypass "_return" rule on select on a view. |
Date: | 2015-05-28 09:19:58 |
Message-ID: | 5566DDBE.5040304@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
Il 28.05.2015 08:23, Shashwat Arghode ha scritto:
> 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
>
> and i don't want to drop the view.
>
> when i try to disable it using :
> alter table viewname disable rule _return
> it returns
> ERROR: "viewname" is not a table
>
>
> Bypassing rule for a single query or disabling it for some time and
> then enable it will also work for me.
>
> Can it be done ?
>
> Thanks,
> Shashwat.
Hi Shashwat
I am no PG guru but I guess that, since "viewname" is a view and not a
table, you should use "alter view" and not "alter table". See:
http://www.postgresql.org/docs/9.3/static/sql-alterview.html
From | Date | Subject | |
---|---|---|---|
Next Message | Shashwat Arghode | 2015-05-28 09:44:33 | Re: Drop or disable or bypass "_return" rule on select on a view. |
Previous Message | Nivedita Kulkarni | 2015-05-28 07:14:14 | [Postgresql NLS support] : Help on using NLS , Custom dictionary to enhance our website search functionality |
From | Date | Subject | |
---|---|---|---|
Next Message | Shashwat Arghode | 2015-05-28 09:44:33 | Re: Drop or disable or bypass "_return" rule on select on a view. |
Previous Message | Shashwat Arghode | 2015-05-28 06:23:45 | Drop or disable or bypass "_return" rule on select on a view. |