1
edit
Changes
→CREATING SCHEMA -- PostgreSQLSchemaManager.java
=== CREATING SCHEMA -- ''PostgreSQLSchemaManager.java''===
:: 1- DATA TYPE: data types are changed in '''''<code> appendColumnType() </code>''''' based on each jdbc type's equivalent in PostgreSQL.
:::*[http://db.apache.org/ddlutils/databases/postgresql.html mapping JDBC data types to PostgreSQL data types]
</source>
:The implementation in '''''<code> crateTextTable() </code>''''' is removed for now (base class's version is being called).
:TODO To be checked if it's the case for PostgreSQL as well.
:The implementation in '''''<code> createIndex() </code>''''' is removed for now (base class's version is being called).
:TODO To be checked if it's the case for PostgreSQL as well.
:Note- If there was a complain for duplicate index name, a fully qualified name can be used. Just note that PostgreSQL doesn't like fully qualified name as <code>table.indexname</code> for indexes or triggers, instead a '_' can be used: <code>table_indexname</code>
:TODO To be checked if triggers are needed for PostgreSQL as well. It's not an abstract method in '''''SQLSchemaManager.java'''''.
: <code>'''''createTrigger()'''''</code> is added to '''''MySQLSchemaManager.java'''''