From: Jan Wieck <janwieck@Yahoo.com>
To: Basilis Kladis <bkladis@knowledge.gr>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem with keyword 'old'
Date: Sun, 3 Dec 2000 11:06:34 -0500 (EST)
Message-ID: <200012031606.LAA08166@jupiter.jw.home> (raw)
In-Reply-To: <NEBBKLFBPKPJGEGPOLOEOEKCCBAA.bkladis@knowledge.gr>
Basilis Kladis wrote:
[Charset iso-8859-7 unsupported, filtering to ASCII...]
> I am ussing Postgresql v. 6.3 in a RedHat Linux system. I try to create a
> rule to log the deletes on table 'filter' ussing the following:
First of all, the rule system up to version 6.3 is known to
be broken in several ways. And IIRC delete rules where one of
the cases that didn't work reliable.
To answer your question, in 6.3 the old row is identified by
the keyword CURRENT, not OLD.
Jan
>
> CREATE RULE log_delete_filter AS ON DELETE TO filter
> DO
> INSERT INTO log_activity (mod_table, mod_record, mod_type)
> VALUES ('filter', old.did, 'D');
>
> The atributes of tables are:
> filter (did int4, text text)
> log_activity (mod_table char(20), mod_rec int4, mod_type char(1) )
>
> I have the following result:
> ERROR: old: Table does not exist.
> and the rule is not created.
>
> I tested a same rule on INSERT with the keyword new.did and is working
> perfect.
> Also I tested the commands:
> SELECT new.did;
> > ERROR: NEW used in non-rule query
> SELECT current.did;
> >ERROR: CURRENT used in non-rule query
> SELECT old.did;
> >ERROR: old: Table does not exist.
>
> What is going on? Do you have any idea why does system not undestand
> keyword 'old'?
>
> Sincerely,
> Basilis Kladis <bkladis@knowledge.gr>
>
> _______ ______
> Language Engineering Dept.
> KNOWLEDGE S.A.
>
--
#======================================================================#
# 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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: janwieck@Yahoo.com, bkladis@knowledge.gr
Subject: Re: problem with keyword 'old'
In-Reply-To: <200012031606.LAA08166@jupiter.jw.home>
References: <NEBBKLFBPKPJGEGPOLOEOEKCCBAA.bkladis@knowledge.gr> <200012031606.LAA08166@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