Add trigger support to PostgreSQL producer and parser (including trigger scope)

[dbsrgits/SQL-Translator.git] / Changes

diff --git a/Changes b/Changes
index eb128a1..a0cc90e 100644 (file)
--- a/Changes
+++ b/Changes
@@ -1,10 +1,41 @@
+* Support for triggers in PostgreSQL producer and parser
+* Correct Data Type in SQLT::Parser::DBI::PostgreSQL (patch from Andrew Pam)
+* Fix index issue in SQLT::Parser::DBI::PostgreSQL
+* Add column and table comments in SQLT::Parser::DBI::PostgreSQL(patch from Andrew Pam)
+* Fixed alter_drop_constraint for foreign keys and applying multiple changes
+  via alter_field to a column in Postgres Producer
+* added a working mechanism for naming foreign keys in the PostgreSQL producer
+* Fix possible name duplication in SQLlite producer
+* Oracle does not accept ON DELETE/UPDATE RESTRICT (though it is the actual default)
+  fix by not adding the ON DELETE/UPDATE clause at all
 
+# ----------------------------------------------------------
+# 0.11010 2011-10-05
+# ----------------------------------------------------------
+
+* Add "if exists" to drop view statements in Pg.
+
+# ----------------------------------------------------------
+# 0.11009 2011-09-02
+# ----------------------------------------------------------
+
+* Fix MySQL producer to properly quote all table names on output (patch from geistteufel)
+
+# ----------------------------------------------------------
+# 0.11008 2011-05-04
+# ----------------------------------------------------------
+
+* Correctly create and parse FK constraints in SQLite
 * Correct postgis geography type insertion and linebreak fix for multiple geometry/geography columns
 * made PostgreSQL producer consistent with other producers in terms of
   quoting and allowing functions in constraints and indices
 * Add distinction of autoinc and regular primary keys to the GraphViz producer
 * Fix odd invocation of Test::More::pass() in t/36-filters.t (RT#64728)
 * Quote everything in SQL Server
+* Turn off constraints before dropping tables in SQL Server
+* Make true unique constraints if needed in SQL Server
+* Fixed Producer::PostgresSQL to output array type after type size,
+  i.e. varchar(64)[] rather than varchar[](64)
 
 # ----------------------------------------------------------
 # 0.11007 2010-11-30