Django sql/syncdb commands fail with PostgreSQL backend

Question

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?

Please show create table statement which is execute for Postgres (it is not the one you posted). — user330315
– user330315, Commented Apr 9, 2013 at 13:59
Why are you querying from the DB when generating sql? Looks like you have a query that triggers on module load... tut tut... — Thomas
– Thomas, Commented Apr 9, 2013 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
– janeden, Commented Apr 9, 2013 at 14:59

janeden · Accepted Answer · 2013-04-09 15:52:17Z

1

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!

answered Apr 9, 2013 at 15:52

janeden

4614 silver badges12 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Django sql/syncdb commands fail with PostgreSQL backend

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related