Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-37

auto increment can not be added to a column, when postgresql is used.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-BETA2
    • Fix Version/s: 2.0.0-BETA3
    • Component/s: Platforms
    • Labels:
      None
    • Environment:
      Linux

      Description

      To add auto increment to on column using the following code in the
      migration class:

      $systemSettingsTable->changeColumn('setting_id',
      array('autoincrement' => true));
      or
      $settingIdColumn = $systemSettingsTable->getColumn('setting_id');
      $settingIdColumn->setAutoincrement(true);

      This works fine when MySQL is used. But when PostGreSQL is used, this
      statement doesn't create any SQL statement.

      The patch in attachment could perhaps resolve this problem some way.

        Activity

        tiw Ting Wang created issue -
        beberlei Benjamin Eberlei made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.0.0-BETA3 [ 10066 ]
        Resolution Fixed [ 1 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira [ 11674 ] jira-feedback2 [ 17654 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17654 ] jira-feedback3 [ 20009 ]

          People

          • Assignee:
            beberlei Benjamin Eberlei
            Reporter:
            tiw Ting Wang
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: