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 vie
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