Re: problem with keyword 'old'

From: Jan Wieck <janwieck(at)Yahoo(dot)com>
To: Basilis Kladis <bkladis(at)knowledge(dot)gr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: problem with keyword 'old'
Date: 2000-12-03 16:06:34
Message-ID: 200012031606.LAA08166@jupiter.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)knowledge(dot)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(at)Yahoo(dot)com #

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-12-03 23:17:48 Re: Rules with Conditions: Bug, or Misunderstanding
Previous Message Edipo E. F. Melo 2000-12-02 15:20:04 Re: I can be a BUG?