[jira] Created: (DDLUTILS-248) set max identifier length from 31 to 63 for PostgreSQL

[Tomislav Nakic-Alfirevic (JIRA)]

set max identifier length from 31 to 63 for PostgreSQL
------------------------------------------------------

                 Key: DDLUTILS-248
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-248
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - PostgreSql
         Environment: Ubuntu 9.04, openjdk 6.0 u13
            Reporter: Tomislav Nakic-Alfirevic
            Assignee: Thomas Dudziak
            Priority: Minor


I used ddlutils with a PostgreSQL database which had identifiers longer than 31 
characters which would break my ant scripts.
This change fixed it:
Index: main/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
===================================================================
--- main/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java   
(revision 753277)
+++ main/java/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java   
(working copy)
@@ -69,7 +69,7 @@
         info.setPrimaryKeyColumnAutomaticallyRequired(true);
         // this is the default length though it might be changed when building 
PostgreSQL
         // in file src/include/postgres_ext.h
-        info.setMaxIdentifierLength(31);
+        info.setMaxIdentifierLength(63);
 
         info.addNativeTypeMapping(Types.ARRAY,         "BYTEA",            
Types.LONGVARBINARY);
         info.addNativeTypeMapping(Types.BINARY,        "BYTEA",            
Types.LONGVARBINARY);


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.