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