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-208) PostgreSQL: RecreateTableChange loses autoIncrement
Date Tue, 03 Jun 2008 12:52:44 GMT
PostgreSQL: RecreateTableChange loses autoIncrement

                 Key: DDLUTILS-208
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-208
             Project: DdlUtils
          Issue Type: Bug
          Components: Core (No specific database), Core - PostgreSql
         Environment: PostgreSQL 8.3.1
            Reporter: Rijk van Haaften
            Assignee: Thomas Dudziak
             Fix For: 1.1

PlatformImplBase.processChange(RecreateTableChange) does not migrate (autoincrement) sequences,
but does call SqlBuilder.dropTables. PostgreSqlBuilder.dropTables explicitly drops the sequences:
        for (int idx = 0; idx < columns.length; idx++)
            dropAutoIncrementSequence(table, columns[idx]);
(On the other hand, HsqlDbBuilder does not drop the sequence for instance.)
The sequence is created again, but that causes 'duplicate' errors on the column using the

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

View raw message