Skip site navigation (1) Skip section navigation (2)

Pyrseas 0.5.0 is now available

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 (view raw or flat)
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

pgsql-announce by date

Next:From: David FetterDate: 2012-03-12 05:46:12
Subject: == PostgreSQL Weekly News - March 11 2012 ==
Previous:From: SQL Maestro GroupDate: 2012-03-09 10:16:38
Subject: PostgreSQL Code Factory 12.3 released

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group