Skip site navigation (1) Skip section navigation (2)

Re: Feature request: drop rules

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Thom Brown <thombrown(at)gmail(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Feature request: drop rules
Date: 2010-07-21 13:06:01
Message-ID: 5cff57865a723284aa22de4fb129b619@localhost (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2010-07-21 13:12:24
Subject: Re: Feature request: drop rules
Previous:From: Dave PageDate: 2010-07-21 13:04:09
Subject: Re: Feature request: drop rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group