Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/schema-test

145 bytes added, 11:11, 10 December 2010
Modifying Syntax
* '''''PostgreSQLSchemaManager.java'''''
: <code> CREATE TABLE test.xxx </code>
:: 1- data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.[http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Data_Types Here] is a tabular comparison between Postgre and MySQL data types. Also
:: 2- In MySQL, the storage engine is set to a transactional safe engine such as [http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#MySQL:InnoDB InnoDB], whereas PostgreSQL has a single built in engine. So, implementation of <code> appendTableSuffix() </code> in PostgreSQLManager.java was removed
::
1
edit