Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/schema-test

4 bytes removed, 18:57, 14 December 2010
CREATING SCHEMA -- PostgreSQLSchemaManager.java
=== CREATING SCHEMA -- ''PostgreSQLSchemaManager.java''===
** <u><code> CREATE TABLE </code></u>
:: 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>
**<u><code> CREATE TEXT TABLE </code></u>
: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.
** <u><code>CREATE INDEX </code></u>
: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>
** <code> <u> CREATE Trigger </u></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'''''
1
edit