Bug related with permissions - VIEWS and RULES

Поиск
Список
Период
Сортировка
От Luis Sousa
Тема Bug related with permissions - VIEWS and RULES
Дата
Msg-id 40EA63CD.9080008@ualg.pt
обсуждение исходный текст
Ответы Re: Bug related with permissions - VIEWS and RULES  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список 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 по дате отправления:

Предыдущее
От: Luke McFarlane
Дата:
Сообщение: ecpg -D SYMBOL
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Bug related with permissions - VIEWS and RULES