Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-37

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

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major 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

        Ting Wang created issue -
        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 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 11674 ] jira-feedback2 [ 17654 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17654 ] jira-feedback3 [ 20009 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: