On 21 July 2010 14:06, Guillaume Lelarge <guilla...@lelarge.info> wrote:
> On Wed, 21 Jul 2010 14:04:09 +0100, Dave Page <dp...@pgadmin.org> wrote:
>> On Wed, Jul 21, 2010 at 2:01 PM, Thom Brown <thombr...@gmail.com> wrote:
>>> On 21 July 2010 10:45, Thom Brown <thombr...@gmail.com> wrote:
>>>> On 21 July 2010 10:38, Guillaume Lelarge <guilla...@lelarge.info>
> wrote:
>>>>> On Wed, 21 Jul 2010 10:23:33 +0100, Thom Brown <thombr...@gmail.com>
>>>>> wrote:
>>>>>> On 21 July 2010 10:03, Guillaume Lelarge <guilla...@lelarge.info>
>>>>>> wrote:
>>>>>>> On Wed, 21 Jul 2010 09:43:33 +0100, Thom Brown
> <thombr...@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
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
