On Thu, Jan 15, 2009 at 5:14 AM, Jasen Betts <[email protected]> wrote: > On 2009-01-14, Gerhard Heift <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
