Re: Feature request: drop rules

On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> On 21 July 2010 10:45, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>> On 21 July 2010 10:38, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>>> On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown <thombrown(at)gmail(dot)com>
>>> wrote:
>>>> On 21 July 2010 10:03, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>>>>> On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown <thombrown(at)gmail(dot)com>
>>>>> wrote:
>>>>>> I noticed you can't drop rules from the GUI.  Could this be added?
>>>>>>
>>>>>
>>>>> It's already available. I see it, and I can drop a rule.
>>>>>
>>>>> --
>>>>
>>>> Hmm... then it might be my version.  I'm using 1.12.0 beta 3 rev 8448.
>>>> (see attached)
>>>>
>>>
>>> You also don't have the right to create a rule. Are you connected with a
>>> superuser? If not, try with this. And what's your release of PostgreSQL?
>>>
>>
>> Yes, I'm connected as a superuser, and created the rule as the
>> superuser too.  I can manually drop it.  I've tested this using
>> PostgreSQL 8.3.1, 8.4.4 and 9.0 beta 3.
>>
>> If I use pgAdmin III 1.10.3, I get the drop option. (image attached)
>>
>> Thom
>>
>
> So did someone accidently tear out some code to make pgAdmin think
> rules can't be dropped?  I'm unable to confirm whether this happens in
> 1.12.0 beta 1 and 2.  But it doesn't seem to matter whether I'm an
> ordinary user or a superuser.

Can't see anything obvious. I'm poking around in the debugger now...

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company