PostgreSQL 9.1.5

PostgreSQL Global Development Group - (Freeware)

PostgreSQL is a good choice when it comes to object-relational database management system, being one of the strongest competitors for Microsoft SQL Server, Firebird, Oracle, Sybase.

PostgreSQL for Windows is a software for managing relational database and Ordbms objects that will run on your operating system. It is recognized worldwide for its stability and its programming possibilities particularly extensive in the engine of your database using the PL / pgSQL.

PostgreSQL is the main competitor for MySQL, Firebird, Oracle, Sybase or Microsoft SQL Server and it is fully ACID compliant and has support for foreign keys, joins, views, triggers, and stored procedures. It also includes the windowing functions, common table expressions and recursive joins a parallel restore, consolidated hash indexes, support for SSL certificates for user authentication, routines statistics function, etc.It allows to manage tables, libraries for many languages to access records from programs written in Java (JDBC), C + + / C, Perl or Tcl / Tk.ODBC API allows any application that supports this type of interface to access PostgreSQL databases.

PostgreSQL is highly customizable running stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby, Tcl, C/C++,and its own PL/pgSQL, which is similar to Oracle's PL/SQL.

Title:: PostgreSQL 9.1.5
File Size:: 46.3 MB
Requirements:: Windows (All Versions)
Language:: en-us
License:: Freeware
Date Added:: 19 Aug 2012
Publisher:: PostgreSQL Global Development Group
Homepage:: http://www.postgresql.org
MD5 Checksum:: 0E74DAFAEA3B125C0BBE425D4D176FEB

# Changes
* Prevent access to external files/URLs via XML entity references
* Prevent access to external files/URLs via contrib/xml2's xslt_process()
* Prevent too-early recycling of btree index pages
* Fix crash-safety bug with newly-created-or-reset sequences
* Fix race condition in enum-type value comparisons
* Fix txid_current() to report the correct epoch when not in hot standby
* Prevent selection of unsuitable replication connections as the synchronous standby
* Fix bug in startup of Hot Standby when a master transaction has many subtransactions
* Ensure the backup_label file is fsync'd after pg_start_backup()
* Fix timeout handling in walsender processes
* Wake walsenders after each background flush by walwriter
* Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space
* Only allow autovacuum to be auto-canceled by a directly blocked process
* Improve logging of autovacuum cancels
* Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start
* Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT)
* Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns
* Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX
* Fix REASSIGN OWNED to work on extensions
* Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE
* Fix memory leak in ARRAY(SELECT ...) subqueries
* Fix planner to pass correct collation to operator selectivity estimators
* Fix extraction of common prefixes from regular expressions
* Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants
* Fix pg_dump to better handle views containing partial GROUP BY lists
* In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding
* Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python
* Fix mapping of PostgreSQL encodings to Python encodings in PL/Python
* Report errors properly in contrib/xml2's xslt_process()
* Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau