diff options
author | Yorhel <git@yorhel.nl> | 2010-11-14 12:21:49 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-11-14 12:21:49 +0100 |
commit | 121b642d3c7ac4b34c644642baf75d34c8466d53 (patch) | |
tree | 4212477ba66fe72efdeb650c1305ca577d9fba5d /ChangeLog | |
parent | a0dff7f8d6ad1aeb508fd1bfb5f7bdbcbf16243a (diff) |
SQL: Added WHEN clause to all TRIGGERs for which it was useful
This effectively removes compatibility with all PostgreSQL versions
below 9.0.
The use of the WHEN clause has two major advantages:
1. Performance: Trigger functions aren't executed when they don't need to.
2. Easier and more general trigger functions; as some of the logic has
been placed in the trigger definitions now.
Diffstat (limited to 'ChangeLog')
-rw-r--r-- | ChangeLog | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -2,6 +2,8 @@ - Added Atom feeds for the recent announcements, changes and posts (located in /www/feeds and updated every 15 min. by Multi::Feed) - Improved performance of update_vnpopularity() on PostgreSQL 9.0 + - Added WHEN clause to all SQL TRIGGERs for which it was useful + (this *requires* PostgreSQL 9.0 or up!) 2.13 - 2010-11-11 - Added 'formcode' parameter to all modification requests to fix all |