Django not creating tables in Postgres db

Question

So I did some changing around of what is a primary key in my models and django did not like that. I did some reading about why and came up with a complicated solution, that involved creating intermediary tables and then pushing all the data to a final version with they new primary key.

I thought 'Hey, I just have junk test data in there anyway, ill just drop the tables I want to change, delete all the migration history and then re-migrate them over...'

Well I tried that and now Django is running the initial migration and putting it in the migration folder, but when I actually run

python manage.py migrate

I get this output:

Operations to perform:
  Synchronize unmigrated apps: staticfiles, messages
  Apply all migrations: sessions, admin, study, auth, quiz, contenttypes, main
Synchronizing apps without migrations:
  Creating tables...
    Running deferred SQL...
  Installing custom SQL...
Running migrations:
  No migrations to apply.

and my database is still missing the tables I wanted to recreate. Am I missing something here? It should recreate them in my db, right? How do I get it to do this?

Are there any tables still in the database? When django migrates, it creates some support tables that aren't part of your app. If those are still around they may be confusing the framework. — eykanal
– eykanal, Commented Oct 8, 2015 at 2:53
How about python manage.py makemigrations and then python manage.py migrate ? — nehem
– nehem, Commented Oct 8, 2015 at 3:06
Try just running the migration for a specific app: python manage.py migrate quiz — Semprini
– Semprini, Commented Oct 8, 2015 at 3:10

creimers · Accepted Answer · 2015-11-05 07:47:52Z

3

The problem was that in the database, there is a table called django_migrations which keeps a record of applied migrations. I believe that's what eykanal was referring to in the comments. Once I deleted the respective lines and the remaining tables from my app, it created all new ones.

edited Nov 5, 2015 at 7:47

creimers

5,3474 gold badges36 silver badges56 bronze badges

answered Oct 8, 2015 at 5:09

Joff

12.3k20 gold badges65 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user18997868 · Accepted Answer · 2022-04-30 05:31:01Z

1

i have faced the same issue i just went into django_migrations in postgres then deleted my application table. refer the screen shot then its worked enter image description here

answered Apr 30, 2022 at 5:31

user18997868

111 bronze badge

Collectives™ on Stack Overflow

Django not creating tables in Postgres db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related