PostgreSQL Icon

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQLOverview

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.

NEW

* Changes

- In pg_upgrade, remove pg_multixact files left behind by initdb
- Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns
- Protect against torn pages when deleting GIN list pages
- Don't clear the right-link of a GiST index page while replaying updates from WAL
- Fix corner-case infinite loop during insertion into an SP-GiST text index
- Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator
- Fix wraparound handling for pg_multixact/members
- Truncate pg_multixact during checkpoints, not during VACUUM
- Fix possible inconsistency of all-visible flags after WAL recovery
- Fix possibly-incorrect cache invalidation during nested calls to ReceiveSharedInvalidMessages
- Fix race condition when updating a tuple concurrently locked by another process
- Fix "could not find pathkey item to sort" planner failures with UNION ALL over subqueries reading from tables with inheritance children
- Don't assume a subquery's output is unique if there's a set-returning function in its targetlist
- Improve planner to drop constant-NULL inputs of AND/OR when possible
- Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent
- Fix handling of nested JSON objects in json_populate_recordset() and friends
- Fix identification of input type category in to_json() and friends
- Fix failure to detoast fields in composite elements of structured types
- Fix "record type has not been registered" failures with whole-row references to the output of Append plan nodes (Tom Lane)
- Fix possible crash when invoking a user-defined function while rewinding a cursor
- Fix query-lifespan memory leak while evaluating the arguments for a function in FROM
- Fix session-lifespan memory leaks in regular-expression processing
- Fix data encoding error in hungarian.stop
- Prevent foreign tables from being created with OIDS when default_with_oids is true
- Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction
- Clear pg_stat_activity.xact_start during PREPARE TRANSACTION
- Fix REASSIGN OWNED to not fail for text search objects
- Prevent pg_class.relminmxid values from going backwards during VACUUM FULL
- Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace
- Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification
- Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns
- Block signals during postmaster startup
- Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses
- Allow the root user to use postgres -C variable and postgres --describe-config
- Secure Unix-domain sockets of temporary postmasters started during make check
- Fix tablespace creation WAL replay to work on Windows
- Fix detection of socket creation failures on Windows
- On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file
- Properly quote executable path names on Windows
- Fix linking of libpython on OS X
- Avoid buffer bloat in libpq when the server consistently sends data faster than the client can absorb it
- Ensure that LDAP lookup attempts in libpq time out as intended
- Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes
- Fix pg_dump to cope with a materialized view that depends on a table's primary key
- Fix parsing of pg_dumpall's -i switch
- Fix pg_restore's processing of old-style large object comments
- Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not
- In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server
- Prevent contrib/auto_explain from changing the output of a user's EXPLAIN
- Fix query-lifespan memory leak in contrib/dblink
- In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning
- Prevent use of already-freed memory in contrib/pgstattuple's pgstat_heap()
- In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls
- Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.

PostgreSQLInformation

Version
9.3.5
Date
07.25.14
License
Free
Language
English
File Size
52.19MB
Category
SubCategory
Operating Systems
Windows (All Versions)
System Requirements
No additional system requirements.
MySQL Query Browser Icon
The easiest visual tool for creating, executing, and optimizing SQL queries
Free
CASE Studio 2 Icon
Create ER diagrams for various databases, generate SQL scripts, HTML reports
Paid
SQL Dumper Icon
Allows dumping a SQL Server Database to a text file
Free
JumpStart Icon
Database initialization system for SQL Server.
Demo
Crystal Reports Server XI Icon
Transforming data into actionable information accessible anytime, anywhere
Trial
xSQL Script Executor Icon
Execute multiple T-SQL scripts against multiple SQL Server, DB2, and MySQL databases.
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
SQL Prompt Icon
Intelligent code completion and layout for MS SQL Server
Paid
More