PostgreSQL is support storage of binary large objects, including video, sounds, or pictures. PostgreSQL has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. PostgreSQL is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.
New Features
•Fix bugs in information_schema.referential_constraints view (Tom Lane). This view was being insufficiently careful about matching the foreign-key constraint to the depended-on primary or unique key constraint. That could result in failure to show a foreign key constraint at all, or showing it multiple times, or claiming that it depends on a different constraint than the one it really does. Since the view definition is installed by initdb, merely upgrading will not fix the problem. If you need to fix this in an existing installation, you can (as a superuser) drop the information_schema schema then re-create it by sourcing SHAREDIR/information_schema.sql. (Run pg_config --sharedir if you're uncertain where SHAREDIR is.) This must be repeated in each database to be fixed.
•Make contrib/citext's upgrade script fix collations of citext columns and indexes (Tom Lane). Existing citext columns and indexes aren't correctly marked as being of a collatable data type during pg_upgrade from a p...
System Requirements of PostgreSQL 9.1.1
•Windows 7
•Windows 7 x64
•Windows Vista
•Windows Vista x64
•Windows Server 2008
•Windows XP
•Windows XP x64
•Windows Server 2003
•Windows Server 2003 x64
Download
Browse: Home > 2011 > December > Download PostgreSQL 9.1.1
0 Comments:
Post a Comment