PostgreSQL 9.0 beta1 version released

PostgreSQL
9.0 beta1

Release

 

PostgreSQL 9.0

The beta1 database management system is released.

Based on the needs of most users,
PostgreSQL 9.0

The database adds many features that have been requested by the community for many years.

And

Functions, such as easy-to-use database replication, anonymous blocks, and large-scale licensing tools.
The previous major versions were quite conservative in this regard, while 9.0
The version shows that this is a bold new version that provides many tools to meet the wishes of the Community to win support from the community.

 

PostgreSQL

9.0
Major improvements:

·



Allow read-only queries
The standby system for continuous Archiving

·



Allows continuous archiving of standby systems in stream mode

·



New batch Modification

Access permit Mode

·



Added access permission for large objectsPermission Control

·



Anonymous functions are implemented
Do
Statement usage

·



The default language for Server installation is
PL/pgsql

·



PL/perl

Enhanced

·



Allow
SQL
Compatible

Trigger per column

·



New unique deferred key constraint

·



In the memory queue
Listener/notification


Store events instead of using system tables

·



Allow the notification to pass optional string parameters to the listener

·



Added

Support for full-text search synonym dictionary prefixes

·



Gin
Index Using the red/black tree (
Red-black trees
) Create

·



Added
64
Bit
Windows
Supports system compilation and can run
64
Bit
Mode

 

For more details, see:

Http://developer.postgresql.org/pgdocs/postgres/release-9-0.html