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

Поиск
Список
Период
Сортировка
От Henk van den Toorn
Тема BUG #1533: "*OLD*" relation not recognized in CREATE RULE
Дата
Msg-id 20050310093832.97FEAF115C@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1533: "*OLD*" relation not recognized in CREATE RULE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1533
Logged by:          Henk van den Toorn
Email address:      vdtoorn@hotmail.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Kevin HaleBoyes
Дата:
Сообщение: Re: [HACKERS] We are not following the spec for HAVING without GROUP
Следующее
От: "Zeugswetter Andreas DAZ SD"
Дата:
Сообщение: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY