Django migrations errors

Hello!

When I try migrate my django project to a cockroachdb cluster, I get an error when the statement CREATE INDEX “users_user_email_243f6e77_like” ON “users_user” (“email” varchar_pattern_ops) is executed. I use the postgresql driver from Django. When I use a postgresql server I can run the migrations without errors. Can somebody please help me solve this problem?

Thanks!

Hi Hessel,

While CockroachDB is compatible with the Postgres wire protocol, it is not fully compatible with Postgres SQL syntax; it will not be trivial to migrate an application written for a Postgres database to CockroachDB.

In that specific statement, the error is varchar_pattern_ops; CockroachDB does not support column operator classes.