| From: | William Leite Araújo <william(dot)bh(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Rules on 8.0.2 |
| Date: | 2006-01-11 12:15:42 |
| Message-ID: | bc63ad820601110415o75a5a9fcu@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-01-11 12:42:59 | Re: Rules on 8.0.2 |
| Previous Message | Volkan YAZICI | 2006-01-11 11:18:10 | Re: Sequence Manipulation Functions |