From: | Joe Abbate <jma(at)freedomcircle(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | Pyrseas 0.5.0 is now available |
Date: | 2012-03-10 18:37:11 |
Message-ID: | 4F5B9F57.5020408@freedomcircle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2012-03-12 05:46:12 | == PostgreSQL Weekly News - March 11 2012 == |
Previous Message | SQL Maestro Group | 2012-03-09 10:16:38 | PostgreSQL Code Factory 12.3 released |