Re: fire trigger for a row without update? - Mailing list pgsql-hackers

From Jasen Betts
Subject Re: fire trigger for a row without update?
Date
Msg-id gkn29i$16m$2@reversiblemaps.ath.cx
Whole thread Raw
Responses Re: fire trigger for a row without update?  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: fire trigger for a row without update?  ("Brendan Jurd" <direvus@gmail.com>)
List pgsql-hackers
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;



pgsql-hackers by date:

Previous
From: "Marcus Kempe"
Date:
Subject: Re: async notification patch for dblink
Next
From: Jasen Betts
Date:
Subject: Re: inconsistency in aliasing