Re: fire trigger for a row without update?

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.

merlin