Re: Feature request: drop rules

On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> 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...

Works for me with PostgreSQL 9.0 beta 3 and pgAdmin 1.12 beta 3.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com