From: | Shashwat Arghode <shashwatarghode(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Drop or disable or bypass "_return" rule on select on a view. |
Date: | 2015-05-28 06:23:45 |
Message-ID: | CAGgbXsz-kN=j67bi93_38P0j3cFkJw61YnBZJC3LYGmM-LZj0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Nivedita Kulkarni | 2015-05-28 07:14:14 | [Postgresql NLS support] : Help on using NLS , Custom dictionary to enhance our website search functionality |
Previous Message | lmanorders | 2015-05-27 22:07:03 | DLL Problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Vincenzo Campanella | 2015-05-28 09:19:58 | Re: Drop or disable or bypass "_return" rule on select on a view. |
Previous Message | John R Pierce | 2015-05-28 04:57:43 | Re: [SQL] extracting PII data and transforming it across table. |