diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/backends/postgresql/test_introspection.py | 15 | ||||
| -rw-r--r-- | tests/schema/tests.py | 14 |
2 files changed, 17 insertions, 12 deletions
diff --git a/tests/backends/postgresql/test_introspection.py b/tests/backends/postgresql/test_introspection.py index dc95d6ad23..2dfb7514d6 100644 --- a/tests/backends/postgresql/test_introspection.py +++ b/tests/backends/postgresql/test_introspection.py @@ -27,3 +27,18 @@ class DatabaseSequenceTests(TestCase): seqs, [{"table": Person._meta.db_table, "column": "id", "name": "pers_seq"}], ) + + def test_get_sequences_old_serial(self): + with connection.cursor() as cursor: + cursor.execute("CREATE TABLE testing (serial_field SERIAL);") + seqs = connection.introspection.get_sequences(cursor, "testing") + self.assertEqual( + seqs, + [ + { + "table": "testing", + "column": "serial_field", + "name": "testing_serial_field_seq", + } + ], + ) diff --git a/tests/schema/tests.py b/tests/schema/tests.py index c758db8bc8..049e604480 100644 --- a/tests/schema/tests.py +++ b/tests/schema/tests.py @@ -1570,11 +1570,7 @@ class SchemaTests(TransactionTestCase): Author.objects.create(name="Foo") Author.objects.create(name="Bar") - def test_alter_autofield_pk_to_bigautofield_pk_sequence_owner(self): - """ - Converting an implicit PK to BigAutoField(primary_key=True) should keep - a sequence owner on PostgreSQL. - """ + def test_alter_autofield_pk_to_bigautofield_pk(self): with connection.schema_editor() as editor: editor.create_model(Author) old_field = Author._meta.get_field("id") @@ -1591,14 +1587,9 @@ class SchemaTests(TransactionTestCase): ) if sequence_reset_sqls: cursor.execute(sequence_reset_sqls[0]) - # Fail on PostgreSQL if sequence is missing an owner. self.assertIsNotNone(Author.objects.create(name="Bar")) - def test_alter_autofield_pk_to_smallautofield_pk_sequence_owner(self): - """ - Converting an implicit PK to SmallAutoField(primary_key=True) should - keep a sequence owner on PostgreSQL. - """ + def test_alter_autofield_pk_to_smallautofield_pk(self): with connection.schema_editor() as editor: editor.create_model(Author) old_field = Author._meta.get_field("id") @@ -1615,7 +1606,6 @@ class SchemaTests(TransactionTestCase): ) if sequence_reset_sqls: cursor.execute(sequence_reset_sqls[0]) - # Fail on PostgreSQL if sequence is missing an owner. self.assertIsNotNone(Author.objects.create(name="Bar")) def test_alter_int_pk_to_autofield_pk(self): |