Re: Feature request: drop rules

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

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