This eliminates the need for explicit casting in some situations.

这就避免了一些需要显式类型转换的…… ]]> Wed, 26 Aug 2009 01:16:59 GMT

Add a VERBOSE option to the CLUSTER command and clusterdb (Jim Cox) 为 CLUSTER 命令和 clusterdb 增加了 VERBOSE 选项

Decrease memory requirements for recording pending trigger events (Tom) 减少 了等待记录触发器事件的内存消耗。

Indexes 索引

• Dramatically improve the speed of building and accessing hash indexes (Tom Raney, Shreya Bhargava) 戏剧性的提升了构建和访问 hash 索引的速度。

  This allow…… ]]> Wed, 19 Aug 2009 01:37:03 GMT

  Add support for column-level privileges (Stephen Frost, KaiGai Kohei) 支持列 级授权。

  Refactor multi-object DROP operations to reduce the need for CASCADE (Alex Hunsaker) 多对象删除操作对 CASCADE (级联——译者)的依赖降低。

  For example, if table B has a dependency on table A, the command DROP TABLE A, B no longer requires the CASCADE option.

  例如，表 B 依赖于表 A，DROP TABLE A, B 命令不再需要 CASCADE…… ]]> Thu, 13 Aug 2009 14:56:22 GMT

  Improve optimizer statistics calculations (Jan Urbanski, Tom) 优化统计计算。

  In particular, estimates for full-text-search operators are greatly improved. 特

  别是，全文搜索操作有极大的提升。

  Allow SELECT DISTINCT and UNION/INTERSECT/EXCEPT to use hashing (Tom) 允许 SELECT DISTINCT 和 UNION/INTERSECT/EXCEPT 使用 hash。

  This means that these types of queries no longer automatically produce sor…… ]]> Thu, 13 Aug 2009 14:56:22 GMT

  Improve optimizer statistics calculations (Jan Urbanski, Tom) 优化统计计算。

  In particular, estimates for full-text-search operators are greatly improved. 特

  别是，全文搜索操作有极大的提升。

  Allow SELECT DISTINCT and UNION/INTERSECT/EXCEPT to use hashing (Tom) 允许 SELECT DISTINCT 和 UNION/INTERSECT/EXCEPT 使用 hash。

  This means that these types of queries no longer automatically produce sor…… ]]> Thu, 30 Jul 2009 01:33:44 GMT A dump/restore using pg_dump is required for those wishing to migrate data from any previous release.

  从旧版本迁移数据之前，必须要用 pg_dump 备份数据。

  Observe the following incompatibilities:

  注意以下不兼容问题：

  General 普遍性

  • Use 64-bit integer datetimes by default (Neil Conway) 默认使用 64 位整数计时 Previously this was selected by configure's —enable-integer-datetimes option. To retain the old behavior, build with —disable-in…… ]]> Fri, 24 Jul 2009 15:35:01 GMT

    昨天朋友发来一个代码给我，可以让 windows 上的 emacs 窗体像 X 或苹果那样实现半透 明。代码并不复杂：

    (set-frame-parameter (selected-frame) 'alpha (list 85 50))
    (add-to-list 'default-frame-alist (cons 'alpha (list 85 50)))
    

    然后经过一番努力，我写了一个切换功能，按f7进入透明，按f8退出透明状态。

    (defun transform-window (a ab)
      (set-frame-parameter (selected-frame) 'alpha (list a ab)……  ]]>
    			
    			
    			
    			
    			
    			
    			
    			Thu, 23 Jul 2009 11:21:33 GMT
    			
    			After many years of development, PostgreSQL has become
    feature-complete in many areas. This release shows a targeted approach
    to adding features (e.g., authentication, monitoring, space reuse), and
    adds capabilities defined in the later SQL standards. The major areas
    of enhancement are:
    
    经过多年开发后，PostgreSQL 在很多方面都具有了完备的功能。这次发布定位于添加功能（例如授权、监控、空间回收），以及添加最新 SQL  标准中的新功能。主要的增强在于以下几个方面：