Re: Feature request: drop rules
От | Thom Brown |
---|---|
Тема | Re: Feature request: drop rules |
Дата | |
Msg-id | AANLkTim7a2B0TnBH88tME3Z_MpCWI0SLuRdGhNmlSvWg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Feature request: drop rules (Guillaume Lelarge <guillaume@lelarge.info>) |
Ответы |
Re: Feature request: drop rules
(Guillaume Lelarge <guillaume@lelarge.info>)
|
Список | 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
В списке pgadmin-hackers по дате отправления: