2. business software
  3. news
  4. reviews
  5. top apps
下载 PostgreSQL 10.1

PostgreSQL 10.1


PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.

标题: PostgreSQL 10.1
文件名: postgresql-10.1-1-windows.exe
文件大小: 153.29MB (160,737,768 字节)
要求: Windows (所有版本)
语言: 多种语言
许可证: 免费软件
加入日期: 十一月 9,2017
作者: PostgreSQL Global Development Group
MD5 校验和: 0A95566966AA6A9408475AA4A74B30CE

Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases.
Fix crash due to rowtype mismatch in json{b}_populate_recordset().
Fix sample server-start scripts to become $PGUSER before opening $PGLOG.
Fix BRIN index summarization to handle concurrent table extension correctly.
Fix possible failures during concurrent updates of a BRIN index.
Prevent logical replication from setting non-replicated columns to nulls when replicating an UPDATE.
Fix logical replication to fire BEFORE ROW DELETE triggers when expected.
Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language.
Ignore CTEs when looking up the target table for INSERT/UPDATE/DELETE, and prevent matching schema-qualified target table names to trigger transition table names.
Avoid evaluating an aggregate function's argument expression(s) at rows where its FILTER test fails.
Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable.
Fix query-lifespan memory leakage while evaluating a set-returning function in a SELECT's target list.
Allow parallel execution of prepared statements with generic plans.
Fix incorrect parallelization decisions for nested queries.
Fix parallel query handling to not fail when a recently-used role is dropped.
Fix crash in parallel execution of a bitmap scan having a BitmapAnd plan node below a BitmapOr node.
Fix json_build_array(), json_build_object(), and their jsonb equivalents to handle explicit VARIADIC arguments correctly.
Fix autovacuum's “work item” logic to prevent possible crashes and silent loss of work items.
Fix corner-case crashes when columns have been added to the end of a view.
Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes.
Correctly detect hashability of range data types.
Correctly ignore RelabelType expression nodes when examining functional-dependency statistics.
Prevent sharing transition states between ordered-set aggregates.
Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier.
Fix low-probability loss of NOTIFY messages due to XID wraparound.
Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system.
Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher.
Fix AggGetAggref() to return the correct Aggref nodes to aggregate final functions whose transition calculations have been merged.
Fix insufficient schema-qualification in some new queries in pg_dump and psql.
Avoid use of @> operator in psql's queries for \d.
Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing.
Fix libpq to not require user's home directory to exist.
In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set.
Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected.
Fix missing temp-install prerequisites for check-like Make targets.
Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.
In the documentation, restore HTML anchors to being upper-case strings.