It's a bug???? 8-()
| От | Vic |
|---|---|
| Тема | It's a bug???? 8-() |
| Дата | |
| Msg-id | 39F382E2.A195C953@dcc.dp.ua обсуждение исходный текст |
| Ответы |
Re: It's a bug???? 8-()
|
| Список | 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.
В списке pgsql-novice по дате отправления: