[GENERAL] help with simple rule

[Chris Hayner]

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



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]