From f944cb3d3bc17a97216f8990ff3bb4bee14b6f6b Mon Sep 17 00:00:00 2001 From: Dolan Antenucci Date: Tue, 19 Mar 2019 13:28:47 -0600 Subject: Fixed #30266 -- Kept a sequence owner when altering an AutoField/BigAutoField on PostgreSQL. --- django/db/backends/postgresql/schema.py | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'django/db/backends/postgresql/schema.py') diff --git a/django/db/backends/postgresql/schema.py b/django/db/backends/postgresql/schema.py index f0df8ad570..3319ee09a9 100644 --- a/django/db/backends/postgresql/schema.py +++ b/django/db/backends/postgresql/schema.py @@ -11,6 +11,7 @@ class DatabaseSchemaEditor(BaseDatabaseSchemaEditor): sql_create_sequence = "CREATE SEQUENCE %(sequence)s" sql_delete_sequence = "DROP SEQUENCE IF EXISTS %(sequence)s CASCADE" sql_set_sequence_max = "SELECT setval('%(sequence)s', MAX(%(column)s)) FROM %(table)s" + sql_set_sequence_owner = 'ALTER SEQUENCE %(sequence)s OWNED BY %(table)s.%(column)s' sql_create_index = "CREATE INDEX %(name)s ON %(table)s%(using)s (%(columns)s)%(extra)s%(condition)s" sql_delete_index = "DROP INDEX IF EXISTS %(name)s" @@ -101,6 +102,14 @@ class DatabaseSchemaEditor(BaseDatabaseSchemaEditor): }, [], ), + ( + self.sql_set_sequence_owner % { + 'table': self.quote_name(table), + 'column': self.quote_name(column), + 'sequence': self.quote_name(sequence_name), + }, + [], + ), ], ) else: -- cgit v1.2.1