rename_column does not specify table name

[anonymous]

I renamed a model field from a foreign key to a varchar using:

./manage.py startmigration <app> change_field --auto

When running the migration with:

./manage.py migrate <app>

I got the following error:

db.alter_column('greek_letter', ormfrat.lineentity:greek_letter?)

TypeError?: alter_column() takes at least 4 arguments (3 given)

Going into the migration and adding the table name as the first argument fixes the problem.

When running the migration backwards, I get the following error:

psycopg2.ProgrammingError?: column "greek_letter" cannot be cast to type "pg_catalog.int4"

In order to do the reverse migration I delete the column and create a new one altogether.

I am running south against PostgresSQL using psycopg2.

[andrew]

This is very odd; is there any chance of seeing the before/after models which caused this? Does it happen again if you try in the same situation?

Also, the error you get on backwards() is because you altered an integer column to a text one (most likely), which postgres considers an irreversible operation.

[preston@…]

Just a note that I hit this bug too.

Went from a varchar to a FK column

--auto didn't generate a table name:

# Renaming column for field 'country'.
db.rename_column('country', 'country_id')

[flashingpumpkin@…]

I've gotta second that. Went from varchar to ForeignKey? too and got the same hiccup.

The db backend used is MySQL

(pp)alen@fp:[pp]$ python manage.py startmigration pa profile --auto
 + Added model 'pa.referrercode'
 ~ Changed field 'pa.profile.referrer_code'.
Created 0005_profile.py.

(pp)alen@fp:[pp]$ python manage.py migrate pa
Running migrations for pa:
 - Migrating forwards to 0005_profile.
 > pa: 0005_profile
Traceback (most recent call last):
  File "/home/alen/projects/pp/lib/python2.6/site-packages/south/migration.py", line 307, in run_migrations
    runfunc(orm)
  File "/home/alen/projects/pp/src/pa/pa/migrations/0005_profile.py", line 18, in forwards
    db.rename_column('referrer_code', 'referrer_code_id')
TypeError: rename_column() takes exactly 4 arguments (3 given)
 ! Error found during dry run of migration! Aborting.

[andrew]

Could one of you post the models.py file that's making this happen? (pref. before and after), and the migration?

[anonymous]

Andrew - I was just able to reproduce this with a copy of my code.

The change was going from line 11 (commented out) to line 12 in this paste:
http://dpaste.com/118138/

The Country class is coming from django-countries

-Preston

[anonymous]

The models.py and the pre and post FK change migrations from my test:

http://ptone.com/temp/migrations_issue.zip

-Preston

[ed@…]

My situtation was going from a PositiveSmallIntegerField? to a FK. Same symptoms.

[epottercg@…]

Any progress on this?

[andrew]

Fixed in 0.7.