db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rijk van Haaften (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-199) Postgress AutoIncrement fails
Date Mon, 17 Mar 2008 16:23:25 GMT
Postgress AutoIncrement fails
-----------------------------

                 Key: DDLUTILS-199
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-199
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - PostgreSql
    Affects Versions: 1.0
         Environment: Ubuntu 7.10, PostgreSQL 8.2.6
            Reporter: Rijk van Haaften
            Assignee: Thomas Dudziak
             Fix For: 1.1


class org.apache.ddlutils.platform.postgresql.PostgreSqlBuilder 

writeColumnAutoIncrementStmt(Table, Column)
encloses the parameter of nextval in single quotes. 
print("UNIQUE DEFAULT nextval('");
...
print("')");
which in my case generates
UNIQUE DEFAULT nextval('Entity_id_seq')

The underscore is a 'special' character, so the string Entity_id_seq needs to be in double
quotes. The fix is simple but tricky: the single quotes MUST remain! My local fix (notice
the escaped double quote \" twice):

/**
* {@inheritDoc}
*/
protected void writeColumnAutoIncrementStmt(Table table, Column column) throws IOException
{
    print("UNIQUE DEFAULT nextval('\"");
    print(getConstraintName(null, table, column.getName(), "seq"));
    print("\"')");
}


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


Mime
View raw message