Re: Rules on 8.0.2

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: William Leite Araújo <william(dot)bh(at)gmail(dot)com>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rules on 8.0.2
Date: 2006-01-11 12:42:59
Message-ID: 1CB02AD8-7881-4F02-8AC7-CDAFC710917D@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Filipov 2006-01-11 14:11:18 cursors as table sources
Previous Message William Leite Araújo 2006-01-11 12:15:42 Rules on 8.0.2