"ON INSERT rule may not use OLD" on simple query

Поиск
Список
Период
Сортировка
От Brandon Craig Rhodes
Тема "ON INSERT rule may not use OLD" on simple query
Дата
Msg-id w6bs1j7m9f.fsf@guinness.ts.gatech.edu
обсуждение исходный текст
Ответы Re: "ON INSERT rule may not use OLD" on simple query
Список pgsql-general
Postgresql 7.3.2 gives the error "ON INSERT rule may not use OLD" when
trying to define the following rule:

        CREATE TABLE numbers ( number INTEGER );
        CREATE TABLE other_numbers ( number INTEGER );

        CREATE OR REPLACE RULE number_rule AS
        ON INSERT TO numbers
        DO INSERT INTO other_numbers
          SELECT 1 EXCEPT SELECT 2;

although the rule, even upon close inspection, seems to make no
reference at all to the OLD pseudo-relation.  Given the above table
definitions, the query:

        SELECT 1 EXCEPT SELECT 2;

by itself runs fine and returns 1 as expected.  (We have tested this
against both the unstable Debian package for 7.3.2, and against a copy
compiled locally using the standard source archive.)

--
Brandon Craig Rhodes                         http://www.rhodesmill.org/brandon
Georgia Tech                                            brandon@oit.gatech.edu

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

Предыдущее
От: Richard Welty
Дата:
Сообщение: arrays and pl/pgsql?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.3.2: test select_having ... FAILED