Merlin Moncure wrote:
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.
That's not necessary. HOT does a byte-wise comparison of the actual
values involved, so as long as you don't really change the value, HOT
will still kick in.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
