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 по дате отправления: