Skip site navigation (1) Skip section navigation (2)

Bug related with permissions - VIEWS and RULES

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug related with permissions - VIEWS and RULES
Date: 2004-07-06 08:33:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Hi all,

Can anyone tell me if the bug reported on 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 
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"
    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

Next:From: SZŰCS GáborDate: 2004-07-06 08:58:47
Subject: Immutable function in index
Previous:From: Luke McFarlaneDate: 2004-07-06 05:49:14
Subject: ecpg -D SYMBOL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group