Re: [HACKERS] fire trigger for a row without update?

2009-01-15 Thread Jasen Betts
On 2009-01-14, Gerhard Heift ml-postgresql-20081012-3...@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

Re: [HACKERS] fire trigger for a row without update?

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

Re: [HACKERS] fire trigger for a row without update?

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

Re: [HACKERS] fire trigger for a row without update?

2009-01-15 Thread Brendan Jurd
On Thu, Jan 15, 2009 at 9:14 PM, Jasen Betts ja...@xnet.co.nz wrote: On 2009-01-14, Gerhard Heift ml-postgresql-20081012-3...@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