November 29th, 2002, 05:29 PM
PostgreSQL 7.3 is out
Hey power users,
PostgreSQL 7.3 is out. Here are the major new features (ftp://ftp.postgresql.org/pub/README.v7.3):
(Update: the main FTP side is flooded. Please try an FTP mirror on the bottom of the main www.postgresql.org page.)
Schemas allow users to create objects in separate namespaces,
so two people or applications can have tables with the same
name. There is also a public schema for shared tables.
Table/index creation can be restricted by removing permissions
on the public schema.
PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
Functions returning multiple rows and/or multiple columns are
now much easier to use than before. You can call such a "table
function" in the SELECT FROM clause, treating its output like a
table. Also, PL/pgSQL functions can now return sets.
PostgreSQL now supports prepared queries, for improved
PostgreSQL now records object dependencies, which allows
improvements in many areas. "DROP" statements now take either
CASCADE or RESTRICT to control whether dependent objects are
Functions and procedural languages now have privileges, and
functions can be defined to run with the privileges of their
Both multibyte and locale support are now always enabled.
A variety of logging options have been enhanced.
A large number of interfaces have been moved to http://gborg.postgresql.org where they can be developed and
By default, functions can now take up to 32 parameters, and
identifiers can be up to 63 bytes long. Also, OPAQUE is now
deprecated: there are specific "pseudo-datatypes" to represent
each of the former meanings of OPAQUE in function argument and
Last edited by rycamor; November 29th, 2002 at 05:44 PM.
December 1st, 2002, 09:08 PM
Re: PostgreSQL 7.3 is out
OH MY GOSH! Wooohooo!
Now there is something that has been loooong overdue!