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):
/**
* [EMAIL PROTECTED]
*/
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.
