PostgreSQL 11 beta 2 发布,bug 修复版本

栏目: 软件资讯 · 发布时间: 6年前

内容简介:PostgreSQL 11 beta 2 发布了,PostgreSQL (也叫 Postgres)是一个自由的对象-关系数据库服务器(数据库管理系统),它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Fire...

PostgreSQL 11 beta 2 发布了,PostgreSQL (也叫 Postgres)是一个自由的对象-关系数据库服务器(数据库管理系统),它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird),和对专有系统比如 Oracle、Sybase、IBM 的 DB2 和 Microsoft SQL Server的一种选择。

此版本修复了众多 bug:

  • Several fixes for XML support, including using the document node as the context for XPath queries as defined in the SQL standard, which affects the xpath and xpath_exists functions, as well as XMLTABLE

  • Several fixes related to VACUUM, including potential data corruption issues

  • Fixes for partitioning, including ensuring partitioning works with temporary tables, eliminating a needless additional partition constraint checks on INSERTs and generating incorrect paths for partitionwise aggregates

  • Fix for potential replica server crashes where a replica would attempt to read a recycled WAL segment

  • Fixes for pg_replication_slot_advance including returning NULL if slot is not advanced and changes for how the slot is updated depending on if it is a physical or logical replication slot

  • Ensure pg_resetwal works with relative paths to data directory

  • Fixes for query parallelism, including preventing a crash by ignoring "parallel append" for parallel unsafe paths in a query plan

  • Fix returning accurate results with variance and similar aggregate functions when executed using parallel query

  • Fix issue where COPY FROM .. WITH HEADER would drop a line after every 4,294,967,296 lines processed

  • Ensure the "B" (bytes) parameter is accepted by all memory-related configuration parameters

  • Several fixes for the JSONB transform in PL/Python and PL/Perl

  • Fix for plpgsql checking statements where it needs to check original write statement before rewrite, could cause crash

  • Fix for SHOW ALL to display superuser configuration settings to roles that are allowed to read all settings

  • Fix for pg_upgrade that ensures defaults are written when using the "fast ALTER TABLE .. ADD COLUMN" feature with a non-NULL default

  • Several fixes for memory leaks

  • Several fixes specific to the Windows platform

同时包含 tzdata 版本 2018e。

详情查看发布公告

下载地址:https://www.postgresql.org/download/


【声明】文章转载自:开源中国社区 [http://www.oschina.net]


以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

Ruby Cookbook

Ruby Cookbook

Lucas Carlson、Leonard Richardson / O'Reilly Media / 2006-7-29 / USD 49.99

Do you want to push Ruby to its limits? The "Ruby Cookbook" is the most comprehensive problem-solving guide to today's hottest programming language. It gives you hundreds of solutions to real-world pr......一起来看看 《Ruby Cookbook》 这本书的介绍吧!

HTML 压缩/解压工具
HTML 压缩/解压工具

在线压缩/解压 HTML 代码

CSS 压缩/解压工具
CSS 压缩/解压工具

在线压缩/解压 CSS 代码

RGB转16进制工具
RGB转16进制工具

RGB HEX 互转工具