概述:
包括了一个触发器的样例函数,用于在更新表时插入用户名.
当你从 v6.2 上升级时,如果你选择了输出/恢复的做法,你将会发现 avg(money) 现在可以正确运算了.所有其他的升级在升级了可执行程序后都将生效.
另一个避免输出/恢复的做法是在 psql 中使用下面的 SQL 命令来升级现有的系统表:
update pg_aggregate set aggfinalfn = 'cash_div_flt8' where aggname = 'avg' and aggbasetype = 790;我们需要对包括 template1 在内的所有现有数据库进行上面操作.
Changes in this release ----------------------- Allow TIME and TYPE column names(Thomas) Allow larger range of true/false as boolean values(Thomas) Support output of "now" and "current"(Thomas) Handle DEFAULT with INSERT of NULL properly(Vadim) Fix for relation reference counts problem in buffer manager(Vadim) Allow strings to span lines, like ANSI(Thomas) Fix for backward cursor with ORDER BY(Vadim) Fix avg(cash) computation(Thomas) Fix for specifying a column twice in ORDER/GROUP BY(Vadim) Documented new libpq function to return affected rows, PQcmdTuples(Bruce) Trigger function for inserting user names for INSERT/UPDATE(Brook Milligan)