分类:
2009-08-19 09:37:03
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 选项。
This simplifies creation of data types that use the same internal representation as an existing type.
这样同类的内部类型描述可以作为一个既有的类型,简化了数据类型创建。
This allows more control over the coercion behavior of user-defined types.
这样就可以进一步强制性的控制用户定义类型。
This change allows the following new syntaxes 此改变带来以下新语法:
There is no actual new functionality here, but formerly you had to say ALTER TABLE to do these things, which was confusing.
这样也没带来什么新功能,不过以前都是用 ALTER TABLE 来做这件事,很让人迷惑。
This is SQL-standard syntax for functionality that was already supported.
现在这些功能的 SQL 标准语法都已经得到支持了。
Also, add ALTER TABLE SET WITH OIDS to rewrite the table to add OIDs.
当然,也增加了 ALTER TABLE SET WITH OIDS 以重写表,添加 OID。
This makes collation similar to encoding, which was always configurable per database.
这样,此类配置就可以与一直作为每数据库单独配置的编码一致了。
Note in particular that a new database's encoding and locale settings can be changed only when copying from template0. This prevents possibly copying data that doesn't match the settings.
注意:只能在新建数据库,从 template0 复制的时候可以改变数据库编码。这样可能出现 复制的数据与设置不匹配。