Skip site navigation (1) Skip section navigation (2)

BUG #1533: "*OLD*" relation not recognized in CREATE RULE

From: "Henk van den Toorn" <vdtoorn(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1533: "*OLD*" relation not recognized in CREATE RULE
Date: 2005-03-10 09:38:32
Message-ID: 20050310093832.97FEAF115C@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1533
Logged by:          Henk van den Toorn
Email address:      vdtoorn(at)hotmail(dot)com
PostgreSQL version: 7.4.3-7
Operating system:   Freebsd 5.3
Description:        "*OLD*" relation not recognized in CREATE RULE
Details: 

When creating a rule:

CREATE RULE rulename AS ON UPDATE
table WHERE OLD.index = NEW.index
DO INSTEAD NOTHING;

Postgresql responds with

ERROR: relation "*OLD*" does not exist

All kind of variations on "*OLD*"
like:

old.index; OLD.index; "*OLD*".index

do not work, nor does changing the order of the elements in the WHERE
clause.

Responses

pgsql-bugs by date

Next:From: Alexander M. PravkingDate: 2005-03-10 10:43:07
Subject: ALTER DATABASE ... RENAME: permission denied for superuser
Previous:From: Zeugswetter Andreas DAZ SDDate: 2005-03-10 09:17:50
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group