After many moons of work by Daniele Varrazzo, the undersigned and
others, Pyrseas 0.8, utilities for versioning Postgres database schemas,
has been released. Release 0.8.0 is available from:
PyPI: https://pypi.org/project/Pyrseas/
PGXN: https://pgxn.org/dist/pyrseas/
GitHub: https://github.com/perseas/Pyrseas
Updated documentation is viewable at:
Read the Docs: https://pyrseas.readthedocs.io/en/latest/
The following is a summary of changes and enhancements in this release.
Daniele was the driving force behind the significant rearchitecture of
the methods to generate SQL.
* An object dependency graph is built and traversed to generate SQL
in correct order (#72, #86, #100)
Added support for Postgres 10, specifically:
* Table partitioning syntax (#163)
* Column specification GENERATED AS IDENTITY (#164)
Added support for other Postgres features:
* Parallel safe functions and partial aggregation (#161)
* RANGE types (#173)
* ALTER TYPE ADD VALUE for changes to ENUM types (#87)
I'd like to thank Tobias Bussmann, Denis Smirnov, Vasiliy Yeremeyev,
Roger Hunwicks, and of course, Daniele, and anyone else who contributed
code, discussions on issues or otherwise helped to make this release
possible.
Best regards,
Joe Abbate