From: Jan Wieck <janwieck@Yahoo.com>
Message-Id: <200101022351.SAA12469@jupiter.jw.home>
Subject: Re: Rules
In-Reply-To: <002d01c04a2a$262f2680$6f646ac2@miniraket> from Peeter Smitt at
	"Nov 9, 2000 10:50:44 am"
To: Peeter Smitt <peeter.smitt@online.ee>
Date: Tue, 2 Jan 2001 18:51:07 -0500 (EST)
CC: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Peeter Smitt wrote:
> Hi
>
> I'm trying to make updateable view useing rules.
>
> CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD
>   SELECT fun1(new);
>
> Thing is that backend gives this error.
>   ERROR:  parser: parse error at or near ")"
>
> What i'm doing wrong? Are there any other ways to make updatebale multi-table views?

    There  are,  but you haven't read the documentation about the
    rule system, which is a common mistake.

    Read chapter 8  of  the  PostgreSQL  Programmers  manual  for
    details on how to setup updateable views.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #