From 1b3a949ba26ca8fefde7fa224e11c4aadbbdd724 Mon Sep 17 00:00:00 2001 From: Mariusz Felisiak Date: Fri, 29 Apr 2022 21:43:55 +0200 Subject: Refs #33671 -- Fixed migrations crash when adding collation to a primary key on Oracle. --- django/db/backends/oracle/schema.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'django') diff --git a/django/db/backends/oracle/schema.py b/django/db/backends/oracle/schema.py index d6b04fe9a1..f2a5099110 100644 --- a/django/db/backends/oracle/schema.py +++ b/django/db/backends/oracle/schema.py @@ -91,6 +91,14 @@ class DatabaseSchemaEditor(BaseDatabaseSchemaEditor): elif "ORA-30673" in description and old_field.primary_key: self._delete_primary_key(model, strict=True) self._alter_field_type_workaround(model, old_field, new_field) + # If a collation is changing on a primary key, drop the primary key + # first. + elif "ORA-43923" in description and old_field.primary_key: + self._delete_primary_key(model, strict=True) + self.alter_field(model, old_field, new_field, strict) + # Restore a primary key, if needed. + if new_field.primary_key: + self.execute(self._create_primary_key_sql(model, new_field)) else: raise -- cgit v1.3