Pyrseas

* 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*

* Add support for INSTEAD OF triggers on views (50).

* Eliminated yamltodb generation of spurious REVOKE/GRANT commands
(51).

* Removed setuptools from setup.py install_requires.

* Added support for:

- EXTENSIONs
- COLLATIONs
- OWNER information
- Access privileges (GRANT and REVOKE)
- TABLESPACEs for tables, primary keys and indexes
- MATCH attributes for foreign keys (34)
- ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE
- ENUMs with no labels (31)
- UNLOGGED tables (45)
- CREATE FUNCTION SET configuration_parameter (46)
- PostgreSQL 9.2

* Correctly support index functions/expressions (3, 44).

* Schema-qualify composite types when dropping or renaming
attributes (47)

* Fix DbConnection exception handling under Python 3 (25).

* dbtoyaml

- Fix -t option to output sequences owned by table and the schema
description.
- Use pg_user_mappings view to allow usage by non-superusers.

* yamltodb

- Schema-qualify table when dropping columns (26).
- Correct column drop/add case in middle of table (8).
- Fix adding and dropping of columns in inherited tables (33).
- Enable renaming of indexes (38).
- Ignore all temp schemas (37)

* dbtoyaml/yamltodb

- Give PGUSER precedence over USER environment variable.

* Testing

- Added support, via Tox, for testing against multiple
PostgreSQL/Python combinations

- Changes and documentation for testing on Microsoft Windows

* Added support for:

- TEXTSEARCH parsers, dictionaries, configurations and templates
- FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs and FOREIGN TABLEs
- ROWS clause in set-returning functions (issue 11)
- Deferrable/deferred constraints (13)
- CATEGORY and PREFERRED clauses for TYPEs,
SORTOP clause for AGGREGATEs
HASHES and MERGES clauses for OPERATORs (15)
- Operator class qualifiers for INDEXes (16)
- Python 3.2 and later

* Correct schema normalization for constraints (9) and indexes.

* Fix COMMENTs generated for constraints (12).

* 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 (6).
- Add -u/--update option to apply SQL statements to target
database.
- Exclude database-wide objects when -n/--schema is used (21).
- Allow YAML spec argument to be read from standard input.

* dbtoyaml/yamltodb

- Add -o/--output option
- Add -W/--password option (18)

* Make the initial SET search_path persistent.

* Correct exclusion of PG internal schemas in various queries.

* Fix generation of COMMENTs with single quotes in the text.

* For inherited tables, only generate constraints that are defined
locally.

* Correct generation of ALTER TABLE ADD/DROP COLUMN when input
columns are in different order than original.

* Support PG 9.1 (add description for PL/pgSQL language).

* Added support for:

- CASTs
- CONSTRAINT TRIGGERs
- CONVERSIONs
- OPERATORs, OPERATOR CLASSes and OPERATOR FAMILies
- Dynamically loaded C language functions
- Composite and base TYPEs

* Clean up and enhance documentation and redundant methods.

* Use obj_description/col_description functions instead of querying
pg_description directly.