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
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 ? |