# ----------------------------------------------------------
+# x.xxxxx xxxx-xx-xx
+# ----------------------------------------------------------
+
+# ----------------------------------------------------------
+# 0.09007 2009-06-25
+# ----------------------------------------------------------
+* Fixed Pg parser - caching the compiled P::RD schema is a *very*
+ bad idea
+* Fix MSSQL handling of ON UPDATE/DELETE RESTRICT
+* Delay MSSQL FK constraint deployment until after all CREATE TABLE
+ statements
+* Coerce other engine's bytea/blob/clob datatypes to VarBinary
+
+# ----------------------------------------------------------
+# 0.09006 2009-06-10
+# ----------------------------------------------------------
+* Multiple test and dependency adhustments to make smokers happy
+* Fix YAML producer wrt extra attribute
+* Added support for "time(stamp) (p) with time zone" for Pg producer (mo)
+
+# ----------------------------------------------------------
+# 0.09005 2009-06-08
+# ----------------------------------------------------------
+* Add parser support for MySQL default values with a single quote
+* Properly quote absolute table names in the MySQL producer
+* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis)
+* Added CREATE VIEW subrules for mysql parser (wreis)
+* ALTER TABLE/ALTER COLUMN/DROP DEFAULT support in Pg producer (mo)
+* XML parser support for multi-event triggers
+* SQLite producer support for multi-event triggers
+* XML parser switched from XML::XPath to XML::LibXML
+* Pg producer ALTER TABLE/COLUMN and DROP DEFAULT support
+* MySQL producer skips length attribute for columns which do not support that
+ attribute. Currently following column types are added to that list:
+ date time timestamp datetime year
+* Switch to Module::Install (mandates minimum perl 5.005)
+* Major cleanup of GraphViz proucer
+* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers
+ Fix most of the problems uncovered by the roundtrip test framework
+ Some highlights:
+ - Rewind exhausted globs before attempting a read
+ - Do not add xml comment header if no_comments is set
+ - table/field counts are held per schema object, not globally
+ - no more variable table and column names in SQLite and MSSQL
+ - VIEW support for Pg parser, also some cleanups
+ - The way we generate Pg create view statements was not standards compliant
+ (per RhodiumToad in #postgresql)
+ - Disable MSSQL view/procedure production - they never worked in the first place
+ - SQLite/MSSQL improvements:
+ - Support parsing of all DROP clauses
+ - Support parsing of field-level comments
+ - When producing do not append table names to constraint/index names
+
+# ----------------------------------------------------------
+# 0.09004 2009-02-13
+# ----------------------------------------------------------
+* Add support for temporary tables in Pg (nachos)
+* Create Trigger support for SQLite
+* GraphViz producer improvements
+
+# ----------------------------------------------------------
+# 0.09003 2009-02-07
+# ----------------------------------------------------------
+ <BORKED RELEASE DELETED OFF CPAN>
+
+# ----------------------------------------------------------
# 0.09002 2008-12-05
# ----------------------------------------------------------
* parsing MySQL CURRENT_TIMESTAMP as scalar ref so it can be produced without
projects / dbsrgits/SQL-Translator.git / blobdiff