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

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62

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

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

    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.

    Privileges
    Functions and procedural languages now have privileges, and
    functions can be defined to run with the privileges of their
    creator.

    Internationalization
    Both multibyte and locale support are now always enabled.

    Logging
    A variety of logging options have been enhanced.

    Interfaces
    A large number of interfaces have been moved to http://gborg.postgresql.org where they can be developed and
    released independently.

    Functions/Identifiers
    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
    Posts
    7,322
    Rep Power
    33

    Re: PostgreSQL 7.3 is out


    Originally posted by rycamor
    Hey power users,

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

    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