db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anjana (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6843) Altering the Identity columns rules
Date Thu, 26 Nov 2015 12:44:11 GMT
Anjana created DERBY-6843:

             Summary: Altering the Identity columns rules 
                 Key: DERBY-6843
                 URL: https://issues.apache.org/jira/browse/DERBY-6843
             Project: Derby
          Issue Type: Bug
          Components: Tools
    Affects Versions:,
         Environment: CENTOS
            Reporter: Anjana

We do export of from one derby database to another. Our database defined identity type as
''GENERATED ALWAYS" Due to which the import does not consider the identity column value from
the export file. 

Our requirement is to import those identity column values as well. 
As per understanding one of the option in derby is to create table with identity type as "GENERATED
BY DEFAULT" . However need to understand if there is alternative in derby where in we can
modify the identity type before import to ''GENERATED by DEFAULT" and then after import is
successfully change it back to "GENERATED ALWAYS". 

Appreciate if any one can guide on same. 

This message was sent by Atlassian JIRA

View raw message