Re: fire trigger for a row without update?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: fire trigger for a row without update?
Date: 2009-01-15 10:14:10
Message-ID: gkn29i$16m$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2009-01-15 10:23:16 Re: inconsistency in aliasing
Previous Message Kenneth Lundin 2009-01-15 10:10:54 function to return both table row and varchar

Browse pgsql-hackers by date

  From Date Subject
Next Message Jasen Betts 2009-01-15 10:23:16 Re: inconsistency in aliasing
Previous Message Richard Huxton 2009-01-15 09:47:41 Re: Autovacuum daemon terminated by signal 11