Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to migrate a MySQL-based Django project to PostgreSQL. Unfortunately, all sql/syncdb commands fail as soon as I switch the database backend in settings.py.

python manage.py sql profile w/ MySQL:

BEGIN;
CREATE TABLE `profile_department` (
     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
     `name` varchar(100) NOT NULL UNIQUE,
     [...]

python manage.py sql profile w/ PostgreSQL (psycopg2):

DatabaseError: relation "profile_department" does not exist
LINE 1: ...nt"."homepage", "profile_department"."gd_id" FROM "profile_d...
                                                         ^

Why does Django behave differently with the two DB backends?

share|improve this question
When looking in the database do you have any tables? – limelights Apr 9 at 13:58
Please show create table statement which is execute for Postgres (it is not the one you posted). – a_horse_with_no_name Apr 9 at 13:59
1  
Why are you querying from the DB when generating sql? Looks like you have a query that triggers on module load... tut tut... – Thomas Apr 9 at 14:00
No, the database remains empty – which is expected, as the sql command only prints the SQL statements. – There is no CREATE TABLE statement when the PostgreSQL statement is used – just this error message. – I am not querying from the DB, just trying to create the table in my new (empty) PostgreSQL database (if that succeeds, I'll clean out the DB and issue a syncdb command to load the data from the JSON fixture (created from the MySQL DB using dumpdata). – janeden Apr 9 at 14:59

1 Answer

up vote 1 down vote accepted

Thomas was right, there were indeed two queries buried somewhere in models.py that referred to the Department class:

ROOT_DEPARTMENT = Department.objects.get(pk=14)
FACULTIES = Department.objects.filter(parent=ROOT_DEPARTMENT)

Thanks!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.