Fixed #24533 -- Dropped PostgreSQL sequence and Oracle identity when migrating away from AutoField.

1 files changed, 5 insertions, 0 deletions

diff --git a/tests/schema/tests.py b/tests/schema/tests.py
index e516b17b59..8e992b4917 100644
--- a/tests/schema/tests.py
+++ b/tests/schema/tests.py
@@ -677,6 +677,11 @@ class SchemaTests(TransactionTestCase):
         new_field.model = Author
         with connection.schema_editor() as editor:
             editor.alter_field(Author, old_field, new_field, strict=True)
+        # Now that ID is an IntegerField, the database raises an error if it
+        # isn't provided.
+        if not connection.features.supports_unspecified_pk:
+            with self.assertRaises(DatabaseError):
+                Author.objects.create()
 
     def test_alter_auto_field_to_char_field(self):
         # Create the table