help with simple rule

From: Chris Hayner <hayner80(at)astro(dot)ocis(dot)temple(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: help with simple rule
Date: 2001-03-07 19:32:17
Message-ID: Pine.OSF.4.32.0103071426510.19654-100000@typhoon.ocis.temple.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2001-03-07 19:32:26 Update through views?
Previous Message John Madden 2001-03-07 19:18:41 Re: How robust is postgresql ?