Databases
StackOverflow2013
Postsdbo
PODjango: syncdb not creating new table after dump is loaded
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango: syncdb not creating new table after dump is loaded
    primarykey
    data
    text
    <p>tl;dr: We want to add a new table to the database, without losing previous data.</p> <p>First we took a dump of the database using:</p> <pre><code>$ psql -h localhost dbname &gt; dump_file </code></pre> <p>Then we loaded it to our local db. This is working fine.</p> <p><strong>Problem starts:</strong> On adding a new model to models.py, syncdb doesn't create the table. However, if we create a new db (by deleting the data and running syncdb), it shows up as a created table.</p> <p>This is surprising, because we don't think that adding a new table is a 'schema migration' that syncdb cannot handle. Hence, we don't think South will help here.</p> <p>Is there something I'm missing/getting wrong?</p> <p>This is what our code looks like:</p> <pre><code>class Person(models.Model): # attributes class A(models.Model): # attributes class B(models.Model): a_fk = models.ForeignKey(A) # more attributes class ProblemModel(models.Model) p_fk = models.ForeignKey(Person) a_fk = models.ForeignKey(A) b_fk = models.ForeignKey(B) </code></pre> <p>The output for the concerned table using the command:</p> <pre><code>$ ./manage.py sqlall appname </code></pre> <p>is:</p> <pre><code>CREATE TABLE "appname_problemmodel" ( "id" serial NOT NULL PRIMARY KEY, "p_fk" integer NOT NULL REFERENCES "appname_person" ("p_fk") DEFERRABLE INITIALLY DEFERRED, "a_fk" integer NOT NULL REFERENCES "appname_a" ("id") DEFERRABLE INITIALLY DEFERRED, "b_fk" integer NOT NULL REFERENCES "appname_b" ("id") DEFERRABLE INITIALLY DEFERRED ) </code></pre> <p>Django version 1.5.1</p> <p>ProblemModel is the new model we're trying to add.</p> <p>Thanks in advance for the help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmerlinsbrain
    1. USmerlinsbrain
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs there any other `ForeignKey` definition in your new tables? May be there is a problem about `NULL`able columns in other tables so Django can not create related FK relations. Also checking FK relations before creating the tables may cause problems if data-filled tables have some un-indexed columns(?). I am not sube about the both, but there can be a problem because about those. Do `syncdb`comment executes and finishes or it hangs and waits? Also, did you check your error logs?
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. USFallenAngel
    2. COTaking a wild guess here, but is the actual name of your `ProblemClass` a combination of the names of the other 3 model classes?
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. USzsquare
    3. COWhich model class did you add? Please provide step by step instructions on how to recreate the issue. And what django version.
      singulars
      1. PODjango: syncdb not creating new table after dump is loaded
      1. USuser558061
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload