PostgreSQL 10.1 軟體資訊交流 Mac

winXmac軟體社群 Mac 開發工具 PostgreSQL Global Development Group 免費軟體 Rate 70

PostgreSQL for Mac,軟體教學,軟體下載,軟體社群,Windows軟體,Mac軟體

PostgreSQL 10.1 Mac

PostgreSQL for Mac 是一個功能強大的開源對象關係數據庫系統。它擁有超過 15 年的積極開發和經過驗證的架構,在可靠性,數據完整性和正確性方面贏得了良好聲譽。它運行在所有主要操作系統上,包括 Linux,UNIX(AIX,BSD,HP-UX,SGI IRIX,Mac OS X,Solaris,Tru64)和 Windows。PostgreSQL for Mac 是 Mac OS X Server 上的默認數據庫版本 10.7。

它完全兼容 ACID,完全支持外鍵,連接,視圖,觸發器和存儲過程(使用多種語言)。它包括大多數 SQL:2008 數據類型,包括 INTEGER,NUMERIC,BOOLEAN,CHAR,VARCHAR,DATE,INTERVAL 和 TIMESTAMP。它還支持存儲二進制大對象,包括圖片,聲音或視頻。它具有用於 C / C ++,Java,.Net,Perl,Python,Ruby,Tcl,ODBC 等的原生編程接口,以及特殊的文檔(表格大小可以達到 32TB).

也可用:下載 PostgreSQL for Windows

檔案版本 PostgreSQL 10.1
檔案名稱 postgresql-10.1-1-osx.dmg
系統 Mac OS X 10.10 or later
軟體類型 免費軟體
作者 PostgreSQL Global Development Group
軟體類型 2017-11-10

What's new in this version:

Three security vulnerabilities have been fixed by this release:
- Start scripts permit database administrator to modify root-owned files
- Memory disclosure in JSON functions
- INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges

Bug Fixes and Improvements:
- Fix a race condition in BRIN indexing that could cause some rows to not be included in the indexing
- Fix crash when logical decoding is invoked from a PL language function
- Several fixes for logical replication
- Restored behavior for CTEs attached to INSERT/UPDATE/DELETE statements to pre-version 10
- Prevent low-probability crash in processing of nested trigger firings
- Do not evaluate an aggregate function's argument expressions when the conditions in the FILTER clause evaluate to FALSE. This complies with SQL-standard behavior
- Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable
- Fix memory leak over the lifespan of a query when evaluating a set-returning function from the target list in a SELECT
- Several fixes for parallel query execution, including fixing a crash in the parallel execution of certain queries that contain a certain type of bitmap scan
- Fix json_build_array(), json_build_object(), jsonb_build_array(), and jsonb_build_object() to handle explicit VARIADIC arguments correctly
- Prevent infinite float values from being casted to the numeric type
- Fix autovacuum's “work item” logic to prevent possible crashes and silent loss of work items
- Several fixes for VIEWs around adding columns to the end of a view
- Fix for hashability detection of range data types that are created by a user
- Improvements on using extended statistics on columns for the purposes of query planning
- Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier
- Fix low-probability loss of NOTIFY messages due more than 2 billion transactions processing before any queries are executed in the session
- Several file system interaction fixes
- Correctly restore the umask setting when file creation fails in COPY or lo_export()
- Fix pg_dump to ensure that it emits GRANT commands in a valid order
- Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing to help improve Windows compatibility
- Fix libpq to not require user's home directory to exist when trying to read the "~/.pgpass" file
- Several fixes for ecpg
- This update also contains tzdata release 2017c, with updates for Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago

檔案下載 檔案下載