Pyrseas 0.5.0 is now available

Pyrseas 0.5.0, a framework for upgrading/migrating a PostgreSQL
database, has been released.  It is available from:

   PGXN:       http://pgxn.org/dist/pyrseas/
   PyPI:       http://pypi.python.org/pypi/Pyrseas
   PgFoundry:  http://pgfoundry.org/projects/pyrseas
   GitHub:     https://github.com/jmafc/Pyrseas

Pyrseas now supports additional PostgreSQL DDL features:

    - TEXTSEARCH parsers, dictionaries, configurations and templates
    - FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs and FOREIGN TABLEs
    - ROWS clause in set-returning functions
    - Deferrable/deferred constraints
    - CATEGORY and PREFERRED clauses for TYPEs
    - SORTOP clause for AGGREGATEs
    - HASHES and MERGES clauses for OPERATORs
    - Operator class qualifiers for INDEXes

Pyrseas supports PostgreSQL 8.4, 9.0 and 9.1.  The utilities can be run
under Python 2.6, 2.7 or 3.2.

Other changes:

  * Correct schema normalization for constraints and indexes.

  * Fix COMMENTs generated for constraints.

  * Fix DEFAULT clause for OPERATOR CLASS.

  * dbtoyaml

    - When restricting to specific schemas or tables, include
      non-schema objects (e.g., languages).

  * yamltodb

    - Add -n/--schema option.
    - Add -u/--update option to apply SQL statements to target
      database.
    - Exclude database-wide objects when -n/--schema is used.
    - Allow YAML spec argument to be read from standard input.

  * dbtoyaml/yamltodb

    - Add -o/--output option
    - Add -W/--password option

Thanks to Daniele Varrazzo, Roger Hunwicks and Ronan Dunklau for their
help and code contributions.

Best regards,


Joe Abbate