Re: fire trigger for a row without update?

Merlin Moncure wrote:
> On Thu, Jan 15, 2009 at 5:14 AM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
>> On 2009-01-14, Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de> wrote:
>>> Hello,
>>>
>>> is it possible to call a trigger for a row in a table without updating the
>>> row? I want to do it in plpgsql.
>>> Something like UPDATE table WHERE id = 10;
>> when faced with that problem I do this:
>>
>> UPDATE table SET id=id WHERE id = 10;
>
> One small point. 'id' is probably indexed....to get better advantage
> of 'HOT', try updating a field that is not indexed instead.

That's not necessary. HOT does a byte-wise comparison of the actual
values involved, so as long as you don't really change the value, HOT
will still kick in.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com