Create Rule problems

From: Doug Younger <postgres(at)mindspring(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Create Rule problems
Date: 1999-05-14 17:50:51
Message-ID: 4.1.19990514135041.009646d0@proxy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I'm trying to set up some rules and was following the examples in the
Programmer's guide form the docs, and it gives an example similar to this:

CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data
WHERE NEW.sl_avail != OLD.sl_avail
DO INSERT INTO shoelace_log VALUES (
NEW.sl_name,
NEW.sl_avail,
getpgusername().
'now'::text
);

What I want to do is very similar:

CREATE RULE update_login AS ON UPDATE TO user_info
WHERE NEW.login != OLD.login
DO UPDATE user_dept SET login = NEW.login
WHERE login = OLD.login;

I get an error:
"ERROR: Table old does not exist."
What's going on?

Also, the docs say you can do multiple actions in a rule... what is the syntax?
I tried putting the actions in parens separated by semicolons or commas wit
no luck...
There wasn't an example in the docs that did more than on action.

Thanks,
Doug.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ole Gjerde 1999-05-14 18:04:10 Re: [SQL] JOIN index/sequential select problem
Previous Message Doug Younger 1999-05-14 17:36:33 Create Rule problems