On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page <dpage@pgadmin.org> wrote:
> On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown <thombrown@gmail.com> wrote:
>> On 21 July 2010 10:45, Thom Brown <thombrown@gmail.com> wrote:
>>> On 21 July 2010 10:38, Guillaume Lelarge <guillaume@lelarge.info>
wrote:
>>>> On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown <thombrown@gmail.com>
>>>> wrote:
>>>>> On 21 July 2010 10:03, Guillaume Lelarge <guillaume@lelarge.info>
>>>>> wrote:
>>>>>> On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown
<thombrown@gmail.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