Issue Details (XML | Word | Printable)

Key: DBAL-37
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Benjamin Eberlei
Reporter: Ting Wang
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Doctrine DBAL

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

Created: 22/Jul/10 10:51 AM   Updated: 25/Jul/10 05:32 PM
Component/s: Platforms
Affects Version/s: 2.0.0-BETA2
Fix Version/s: 2.0.0-BETA3

File Attachments: 1. File autoincrementPatch.diff (2 kB)

Environment: Linux


 Description  « Hide
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.



 All   Comments   Change History   FishEye      Sort Order: Ascending order - Click to sort in descending order
Benjamin Eberlei added a comment - 25/Jul/10 05:32 PM
Fixed in current master