Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.2.2
-
Fix Version/s: None
-
Component/s: Migrations
-
Labels:None
-
Environment:Postgresql 8.4 / Symfony 1.4.6
Description
I am still getting the same issue as previously closed a while ago on trac http://trac.doctrine-project.org/ticket/1964
migration.php
<?php /** * This class has been auto-generated by the Doctrine ORM Framework */ class Add_Category_Slug_Index extends Doctrine_Migration_Base { public function up() { $this->addIndex('category', 'category_sluggable', array( 'fields' => array( 0 => 'slug', ), 'type' => 'unique', )); } public function down() { $this->removeIndex('category', 'category_sluggable', array( 'fields' => array( 0 => 'slug', ), 'type' => 'unique', )); } }
The above migration generates an index named category_sluggable instead of category_sluggable_idx
Confirming. I had the same problem last week and as a workaround I had to change suffix from "%s_idx" to "%s". Even if the bug is not reproducible in a test case, it indeed happens in live environment on PostgreSQL (in my case, Symphony is not used).