From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shashwat Arghode <shashwatarghode@gmail.com>
cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Drop or disable or bypass "_return" rule on select on a view.
In-reply-to: 
 <CAGgbXsz-kN=j67bi93_38P0j3cFkJw61YnBZJC3LYGmM-LZj0A@mail.gmail.com>
References: 
 <CAGgbXsz-kN=j67bi93_38P0j3cFkJw61YnBZJC3LYGmM-LZj0A@mail.gmail.com>
Comments: In-reply-to Shashwat Arghode <shashwatarghode@gmail.com>
 message dated "Thu, 28 May 2015 11:53:45 +0530"
Date: Thu, 28 May 2015 09:53:33 -0400
Message-ID: <10237.1432821213@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-novice-owner@postgresql.org

Shashwat Arghode <shashwatarghode@gmail.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


-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice