Re: fire trigger for a row without update?

Merlin Moncure wrote:
> On Thu, Jan 15, 2009 at 5:14 AM, Jasen Betts <jasen@xnet.co.nz> wrote:
>> On 2009-01-14, Gerhard Heift <ml-postgresql-20081012-3518@gheift.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