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-12 20:00:14
Message-ID: Pine.OSF.4.32.0103121459490.18676-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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Limin Liu 2001-03-12 20:13:39 display temp table structure?
Previous Message Aristide Aragon 2001-03-12 19:57:21 varchat ->text