I can't find a similar scenario in the list archives, so ..... I had run the initial migration, etc and all seemed fine.
I modified one model from this: class CCD(models.Model): rm_version = models.ForeignKey(RMversion, related_name='%(class)s_related+') ... to this: class CCD(models.Model): prj_name = models.ForeignKey(Project, verbose_name="Project Name") ... The new ForeignKey in CCD, points to this, which already has the RMversion relation. class Project(models.Model): prj_name = models.CharField("project name", max_length=110, unique=True) rm_version = models.ForeignKey(RMversion, related_name='%(class)s_related+') owner_group = models.CharField(max_length=110) #must be a member of this group to edit this project During the migration, here are the prompts and my responses: (django)tim@tim-us_12-04:~/webapp/apps/mlhim$ python manage.py schemamigration ccdgen --auto ? The field 'CCD.rm_version' does not have a default specified, yet is NOT NULL. ? Since you are removing this field, you MUST specify a default ? value to use for existing rows. Would you like to: ? 1. Quit now, and add a default to the field in models.py ? 2. Specify a one-off value to use for existing columns now ? 3. Disable the backwards migration by raising an exception. ? Please select a choice: 2 ? Please enter Python code for your one-off default value. ? The datetime module is available, so you can do e.g. datetime.date.today() >>> See Project Value ! Invalid input: invalid syntax (<string>, line 1) >>> "See Project RM" - Deleted field rm_version on ccdgen.CCD ? The field 'CCD.prj_name' does not have a default specified, yet is NOT NULL. ? Since you are adding this field, you MUST specify a default ? value to use for existing rows. Would you like to: ? 1. Quit now, and add a default to the field in models.py ? 2. Specify a one-off value to use for existing columns now ? Please select a choice: 2 ? Please enter Python code for your one-off default value. ? The datetime module is available, so you can do e.g. datetime.date.today() >>> "2.4.2" + Added field prj_name on ccdgen.CCD Created 0002_auto__del_field_ccd_rm_version__add_field_ccd_prj_name.py. You can now apply this migration with: ./manage.py migrate ccdgen (django)tim@tim-us_12-04:~/webapp/apps/mlhim$ python manage.py migrate ccdgen Running migrations for ccdgen: - Migrating forwards to 0002_auto__del_field_ccd_rm_version__add_field_ccd_prj_name. > ccdgen:0001_initial FATAL ERROR - The following SQL query failed: CREATE TABLE "ccdgen_rmversion" ("id" serial NOT NULL PRIMARY KEY, "version_id" varchar(10) NOT NULL UNIQUE); The error was: relation "ccdgen_rmversion" already exists Error in migration: ccdgen:0001_initial DatabaseError: relation "ccdgen_rmversion" already exists So, I have this "already exists" error. Any hints on how to fix this? Here is what is installed: Django==1.5 South==0.7.6 Unipath==0.2.1 argparse==1.2.1 distribute==0.6.24 django-extensions==1.1.1 docutils==0.10 psycopg2==2.4.6 six==1.2.0 wsgiref==0.1.2 Using Postgres-9.1 on Unbuntu 12.04LTS As always, THANKS!!! --Tim -- ============================================ Timothy Cook, MSc +55 21 94711995 MLHIM http://www.mlhim.org Like Us on FB: https://www.facebook.com/mlhim2 Circle us on G+: http://goo.gl/44EV5 Google Scholar: http://goo.gl/MMZ1o LinkedIn Profile:http://www.linkedin.com/in/timothywaynecook -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.