1. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power

    Cool 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.

    Drop Column
    PostgreSQL now supports the ALTER TABLE ... DROP COLUMN

    Table Functions
    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.

    Prepared Queries
    PostgreSQL now supports prepared queries, for improved

    Dependency Tracking
    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
    also dropped.

    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
    released independently.

    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
    result types.
    Last edited by rycamor; November 29th, 2002 at 04:44 PM.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  2. #2
  3. Second highest poster :p
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2001
    Rep Power

    Re: PostgreSQL 7.3 is out

    Originally posted by rycamor
    Hey power users,

    Drop Column
    PostgreSQL now supports the ALTER TABLE ... DROP COLUMN

    OH MY GOSH! Wooohooo!

    Now there is something that has been loooong overdue!
    - Andreas Koepke

    Koepke Photography

IMN logo majestic logo threadwatch logo seochat tools logo