Version 6.4 (Released October 1998)

I l @ ve RuBoard

Views and rules are now functional thanks to extensive new code in the rewrite rules system from Jan Wieck. He also wrote a chapter on it for the Programmer's Guide.

Second procedural language, PL/pgSQL, to go with the original PL/pgTCL procedural language.

Optional multiple-byte character set support.

The parser will now perform automatic type coercion to match arguments to available operators and functions and to match columns and expressions with target columns . This uses a generic mechanism that supports the type extensibility features of Postgres. There is a new chapter in the User 's Guide that covers this topic.

Three new data types have been added. Two types, inet and cidr , support various forms of IP network, subnet, and machine addressing. There is now an 8-byte integer type available on some platforms. A fourth type, serial , is now supported by the parser as an amalgam of the int4 type, a sequence, and a unique index.

Several more SQL-92 “compatible syntax features have been added, including INSERT DEFAULT VALUES .

Show the index used in an EXPLAIN .

EXPLAIN invokes rule system and shows plan(s) for rewritten queries.

Multibyte awareness of many data types and functions, via configure .

New configure --with-mb option.

New initdb --pgencoding option.

New createdb -E multibyte option.

Libpq now allows asynchronous clients .

Allowed cancel from client of back-end query.

NOTIFY now sends sender's PID so you can tell whether it was your own.

Added routines to convert between varchar and bpchar.

Added routines to allow sizing of varchar and bpchar into target columns.

Added bit flags to support timezonehour and minute in data retrieval.

Implemented TIMEZONE_HOUR , TIMEZONE_MINUTE per SQL-92 specs .

Check for and properly ignore FOREIGN KEY column constraints.

New psql command "SET CLIENT_ENCODING TO 'encoding'" ; for multibytes feature, see /doc/README.mb .

Libpq can now be compiled on Win32.

Better support for quoted table/column names .

Surrounded table and column names with double quotes in pg_dump .

Allowed UNION in subselects.

Added HAVING clause with full support for subselects and unions.

Support for SQL-92 syntax "SET NAMES" .

Support for LATIN2-5 .

Allowed index use with OR clauses.

EXPLAIN VERBOSE can pretty-print the plan to the postmaster log file.

Allowed GROUP BY on functions.

New rewrite system fixes many problems with rules and views.

System indexes are now multikey.

Removed oidint2 , oidint4 , and oidname types.

New SERIAL data type; autocreates sequence/index.

New UNLISTEN command.

Createuser options now available on the command line.

Code for 64-bit integer (int8) added and tested .

New pg_upgrade command.

New CREATE TABLE DEFAULT VALUES statement available.

New INSERT INTO TABLE DEFAULT VALUES statement available.

New DECLARE and FETCH feature.

Allowed up to eight key indexes.

Removed ARCHIVE keyword that is no longer used.

New SET QUERY_LIMIT .

I l @ ve RuBoard


PostgreSQL Essential Reference
PostgreSQL Essential Reference
ISBN: 0735711216
EAN: 2147483647
Year: 2001
Pages: 118
Authors: Barry Stinson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net