Rules on 8.0.2

Started by William Leite Araújoabout 20 years ago2 messagesgeneral
Jump to latest
#1William Leite Araújo
william.bh@gmail.com

Hi, I'm trying create the rule :

CREATE OR REPLACE RULE select_public_cliente AS ON SELECT TO
public.cliente_tipo
WHERE NOT EXISTS ( SELECT usesysid FROM pg_user left join pg_group on (
idx( grolist, usesysid ) > 0 )
WHERE usename = current_user
ANDgroname SIMILAR
TO 'assinatura' )
DO INSTEAD SELECT clt_dsc_tipo FROM public.cliente_tipo;

Its to limit users to see only one column on table. But I've the
error:

ERROR: event qualifications are not implemented for rules on SELECT

The version is: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC
gcc (GCC) 3.3.5 (Debian 1:3.3.5-5)

Any idea?

--
William Leite Araújo

#2Michael Glaesemann
grzm@seespotcode.net
In reply to: William Leite Araújo (#1)
Re: Rules on 8.0.2

On Jan 11, 2006, at 21:15 , William Leite Araújo wrote:

CREATE OR REPLACE RULE select_public_cliente AS ON SELECT TO
public.cliente_tipo

ERROR: event qualifications are not implemented for rules on SELECT

As the error message indicates, RULEs are not applicable to ON
SELECT. Use a view instead.

Michael Glaesemann
grzm myrealbox com