Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vic <vic(at)dcc(dot)dp(dot)ua>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: It's a bug???? 8-()
Date: 2000-10-23 00:56:21
Message-ID: 3066.972262581@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Vic <vic(at)dcc(dot)dp(dot)ua> writes:
> create rule r_3 as
> on UPDATE to task_l.url do
> update task_l set start_time=now();

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

You'll have better luck (and probably better performance, anyway) doing
this with an ON UPDATE trigger, instead of a rule.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: VicDate: 2000-10-23 01:16:02
Subject: Re: It's a bug???? 8-()
Previous:From: VicDate: 2000-10-23 00:14:26
Subject: It's a bug???? 8-()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group