From: Jan Wieck <janwieck@Yahoo.com>
To: Peeter Smitt <peeter.smitt@online.ee>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rules
Date: Tue, 2 Jan 2001 18:51:07 -0500 (EST)
Message-ID: <200101022351.SAA12469@jupiter.jw.home> (raw)
In-Reply-To: <002d01c04a2a$262f2680$6f646ac2@miniraket>
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 #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: janwieck@Yahoo.com, peeter.smitt@online.ee
Subject: Re: Rules
In-Reply-To: <200101022351.SAA12469@jupiter.jw.home>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox