Changes

PostgreSQL Adapter-nexj/schema-test

266 bytes removed, 11:33, 10 December 2010

→‎Working Inside Schema 'test'

==Working Inside Schema 'test'==

~~: <code> CREATE TABLE test.xxx </code>:: data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.:: The implementation in <code> crateTextTable </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).: <code>CREATE INDEX test.xxx </code>~~ ~~: <code> CREATE Trigger test.xxx // if it's needed for PostgreSQL as well as MySQL</code>~~ * Modifications~~{|class~~=~~"collapsible collapsed" style~~=~~"border-style:solid;border-width:thin;border-color:black"!align~~=~~"left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| '''Changes Done to MySQL adapter'''~~ |- |Initializing the sql

: When a connection is first established, this initial SQL statement should execute in MySQL, which is not the case for PostgreSQL, so it was commented out:

::

)engine=innoDB;

</source>

: <code> CREATE TABLE test.xxx </code>

:: data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.

:: The implementation in <code> crateTextTable </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).

: <code>CREATE INDEX test.xxx </code>

: <code> CREATE Trigger test.xxx // if it's needed for PostgreSQL as well as MySQL</code>

|}

{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"

!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| '''Files to Configure'''

Minooz

1

edit

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/schema-test

CDOT Wiki ^β