Re: Feature request: drop rules - Mailing list pgadmin-hackers

On 21 July 2010 14:06, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> 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.
>

That's odd then.  What if you use the same DDL as myself:

CREATE TABLE entries
(
  id serial NOT NULL,
  username text,
  firstname text,
  lastname text,
  signedup timestamp without time zone
)
WITH (
  OIDS=FALSE
);
ALTER TABLE entries OWNER TO postgres;

CREATE TABLE texts
(
  title text NOT NULL,
  a_text text,
  CONSTRAINT pk_test_title PRIMARY KEY (title)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE texts OWNER TO postgres;

CREATE OR REPLACE RULE insert_test AS
    ON INSERT TO entries
   WHERE new.id = 1 DO INSTEAD  INSERT INTO texts (title, a_text)
  VALUES ('moo'::text, 'bark'::text);

And this is on Windows XP SP3.

Thom