Bug related with permissions - VIEWS and RULES - Mailing list pgsql-bugs

From Luis Sousa
Subject Bug related with permissions - VIEWS and RULES
Date
Msg-id 40EA63CD.9080008@ualg.pt
Whole thread Raw
Responses Re: Bug related with permissions - VIEWS and RULES  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-bugs
Hi all,

Can anyone tell me if the bug reported on
http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg07755.html is
already fixed?
I'm using PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3 (Debian), and I have the same problem described for 7.3.4 and
7.4.1.
This bug can be reproduced creating a table, creating a view over the
table and an insert rule over the view. The rule must be in the format:
CREATE RULE "test_rule" AS ON INSERT TO "test"
    DO INSTEAD(
    INSERT INTO "test" (fld) VALUES (NEW.fld);
    );
If calling a function inside the rule's definition, the permission were
read OK.
SELECT my_func (NEW.fld) AS OK;

Best regards,
Luis Sousa

pgsql-bugs by date:

Previous
From: Luke McFarlane
Date:
Subject: ecpg -D SYMBOL
Next
From: Alvaro Herrera
Date:
Subject: Re: Bug related with permissions - VIEWS and RULES