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
sequence.


-- 
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