Tuesday, January 4, 2011

Re: Changing a constraint with live data

I use south for migrations. I have done something like this
with south, but with postgres not mysql.

I don't know if mysql supports deferrable foreign key constraints.

Thomas

Sithembewena Lloyd Dube wrote:
> Hi everyone,
>
> Happy 2011.
>
> I am having an interesting problem where I need to change the foreign
> key on a model (A) to reference a different model. problem is, the table
> for A
> is populated with records and MySQL does not seem able to drop it. I ran
> manage.py sql and would like to drop the existing constraint and add the
> new one.
> Is there a straightforward way to do this?

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail
: guettli (*) thomas-guettler + de

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment