0.7.3 (28-Nov-2016) Fixed various issues, including: * Exclude constraints installed by extensions (#152) * Generate SQL for changes to indexes and constraints (#144) * Correct order of privileges and options in YAML file (#141) * Fix ALTER TABLE SET STATISTICS (#140) * CLUSTER statement should use fully qualified table name (#133) * Quote column names in ALTER TABLE DROP COLUMN (#114) * Output ALTER COLUMN if column default value changes (#112) 0.7.2 (23-Jan-2015) Fixed various issues, including: * Do not error on tables whose names start with 'public' (#109) * Deal properly with inherited constraints in children tables (#102) * Handle external languages like plv8 correctly (#97) * Correct quoting of mixed case constraint names (#83) * Avoid problems with certain complex index definitions (#98) * Have dbtoyaml output correctly a table with an embedded period in the name and having an associated sequence (#79) * Use relative paths in database summary for ``--multiple-files`` (#93) * Support mapping of indexes on materialized views (#82) 0.7.1 (5-Dec-2013) * Moved ``config.yaml`` under ``pyrseas`` directory and use ``package_data`` to install (#77) * yamltodb output to a file is encoded using utf-8 (#78) 0.7.0 (25-Nov-2013) * 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* 0.6.1 (31-Jan-2013) * 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. 0.6.0 (26-Oct-2012) * 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 0.5.0 (10-Mar-2012) * 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) 0.4.1 (27-Oct-2011) * 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). 0.4.0 (26-Sep-2011) * 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. 0.3.1 (26-Aug-2011) * Added workaround for incorrect assumption that 'public' schema is always present (issue #4). * Added support for delimited (or quoted) identifiers, e.g., those with embedded spaces, upper case characters, etc. (except for SQL keywords) (issue #5). 0.3.0 (30-Jun-2011) * Added support for: - AGGREGATE functions - DOMAINs - ENUMerated TYPEs - Functions returning table row types - INDEXes on expressions (issue #3) - Rewrite RULEs - SECURITY DEFINER functions - TRIGGERs * Enhanced host/port defaults to use sockets, resulting in noticeable performance improvement. 0.2.1 (7-Jun-2011) * Fixed problem with mapping a FOREIGN KEY in a table with a dropped column (issue #2). 0.2.0 (19-May-2011) * Added support for: - COMMENTs on schemas, tables, columns and functions - FOREIGN KEY ON UPDATE and ON DELETE actions - ALTER TABLE RENAME COLUMN and enhanced support for other ALTER object RENAME statements. - VIEWs - INHERITed tables, and by extension, partitioned tables. - PROCEDURAL LANGUAGEs - FUNCTIONs. * Added files for release via PGXN. * Added support for testing against multiple PostgreSQL versions. * Fixed cross-schema REFERENCES failure in dbtoyaml (issue #1). 0.1.0 (5-Apr-2011) * Initial release - dbtoyaml and yamltodb support PostgreSQL schemas, tables, sequences, check constraints, primary keys, foreign keys, unique constraints and indexes.