Rules on 8.0.2

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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