It's a bug???? 8-()

From: Vic <vic(at)dcc(dot)dp(dot)ua>
To: pgsql-novice(at)postgresql(dot)org
Subject: It's a bug???? 8-()
Date: 2000-10-23 00:14:26
Message-ID: 39F382E2.A195C953@dcc.dp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello, deary ALL ! What your say about this :
I-have-a-simple-table :

create table task_l(
n serial,
event text,
URL text, /* ссылка */
PID int, /* PID wget-а для данной
задачи*/
descripition text, /*описание*/
start_time datetime DEFAULT (now()), /* время запуска*/
end_time datetime, /*время останова*/
status text /*результат выполнения :
OK,ERROR,ABORTED */
);
/* AND RULE */
create rule r_3 as
on UPDATE to task_l.url do
update task_l set start_time=now();

AND..... ERROR!!!!:

psql:3.sql:3: ERROR: attribute level rules currently not supported

But is the another solution for that's task : "write in EACH record
date-time last change!(or last select acces)"

Ok. Its not a error - its a feature ( IMHO very stupid ;-\ )
create rule r_3 as
on UPDATE to task_l.url do
^^^^^^^ I remove this and get forever-loop when
user update start_time.
Yes I make field start_time in client read-only, but..... its
solution only for one case !!!!
Does any-body tell me best solution???

with regards Vic.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-10-23 00:56:21 Re: It's a bug???? 8-()
Previous Message Scott Favelle 2000-10-22 19:51:11 RE: database design