| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shashwat Arghode <shashwatarghode(at)gmail(dot)com> |
| Cc: | 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 13:53:33 |
| Message-ID: | 10237.1432821213@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
Shashwat Arghode <shashwatarghode(at)gmail(dot)com> writes:
> 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??
No. I don't exactly see the point, either --- what do you imagine a view
without an ON SELECT rule would be good for?
Perhaps what you want is to replace the view with CREATE OR REPLACE VIEW,
which is basically equivalent to updating its ON SELECT rule. But simply
dropping the rule without immediately replacing it would leave the view
nonfunctional.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2015-05-28 14:17:38 | Re: Drop or disable or bypass "_return" rule on select on a view. |
| Previous Message | Luca Ferrari | 2015-05-28 10:34:00 | Re: Drop or disable or bypass "_return" rule on select on a view. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2015-05-28 14:17:38 | Re: Drop or disable or bypass "_return" rule on select on a view. |
| Previous Message | Luca Ferrari | 2015-05-28 10:34:00 | Re: Drop or disable or bypass "_return" rule on select on a view. |