File Release Notes and Changelog

Release Name: 0.7.0

Release Notes

This is the seventh main release of Pyrseas, a framework for upgrading and migrating a Postgres database. It support Postgres 9.3, 9.2, 9.1, 9.0 and 8.4 and Python 2.x and 3.x.

Change Log

  * Added support for:

    - Postgres 9.3, specifically

      + EVENT TRIGGER
      + MATERIALIZED VIEWS

    - CLUSTER
    - Partial indexes
    - Storage parameters in CREATE and ALTER TABLE
    - ALTER COLUMN SET STATISTICS
    - LEAKPROOF qualifier for FUNCTIONs
    - YAML multi-line string formatting for view definitions,
      function source text and object comments

  * Configuration files

    All Pyrseas utilities can now use YAML-formatted configuration
    files, in addition to command line options

  * Multiple-file input or output

    Spread database object information across a version control
    repository

  * Data export/import

    Load a database with static data in production or data subsets
    for testing

  * dbtoyaml/yamltodb

    - Added --quote-reserved option to yamltodb
    - Exclude arguments from sfunc and finalfunc attributes of
      aggregate functions (#54)
    - Correct generation of SQL for functions with DEFAULT
      arguments (#52)

  * Augmenter

    New utility (dbaugment) to consistently add objects to an
    existent database.  This is currently an experimental
    feature and covers adding audit columns to tables.

  * TTM-inspired relational interface

    A new interface to Postgres, inspired by *The Third Manifesto*
Powered By FusionForge