help with simple rule

Поиск
Список
Период
Сортировка
От Chris Hayner
Тема help with simple rule
Дата
Msg-id Pine.OSF.4.32.0103071426510.19654-100000@typhoon.ocis.temple.edu
обсуждение исходный текст
Ответ на Re: When is 7.1 going out  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: help with simple rule  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
here is the table:

                  Table "testx"
     Attribute |  Type   |      Modifier
    -----------+---------+--------------------
     starter   | integer | not null
     second    | text    | default timestamp('now')

I am trying to make a rule which states:

    whenever someone UPDATES starter, UPDATE second with the current
    timestamp.

here is my attempt at it:

    CREATE RULE testx_update AS ON UPDATE TO testx WHERE (new.starter
    <> old.starter) DO UPDATE testx SET "second" = timestamp('now');

here is the error i am recieving:

    backend=# update testx SET starter =21910 where second = '10000000';
    ERROR:  query rewritten 10 times, may contain cycles

here is my plea for help:

    help!!! ;) seriously, i haven't been able to get this to work and
    i do not know why. any help that anyone can give me would be
    greatly appreciated.


TIA,

--ch


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

Предыдущее
От: Limin Liu
Дата:
Сообщение: display temp table structure?
Следующее
От: "Fernando P. Schapachnik"
Дата:
Сообщение: Re: interval question