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