Re: [GENERAL] Rules on 8.0.2

2006-01-11 Thread Michael Glaesemann
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

[GENERAL] Rules on 8.0.2

2006-01-11 Thread William Leite Araújo
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