summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql/schema.py
diff options
context:
space:
mode:
Diffstat (limited to 'django/db/backends/postgresql/schema.py')
-rw-r--r--django/db/backends/postgresql/schema.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/django/db/backends/postgresql/schema.py b/django/db/backends/postgresql/schema.py
index 3053c8d370..a22ae0094f 100644
--- a/django/db/backends/postgresql/schema.py
+++ b/django/db/backends/postgresql/schema.py
@@ -7,6 +7,13 @@ from django.db.backends.utils import strip_quotes
class DatabaseSchemaEditor(BaseDatabaseSchemaEditor):
+ # Setting all constraints to IMMEDIATE to allow changing data in the same
+ # transaction.
+ sql_update_with_default = (
+ "UPDATE %(table)s SET %(column)s = %(default)s WHERE %(column)s IS NULL"
+ "; SET CONSTRAINTS ALL IMMEDIATE"
+ )
+
sql_delete_sequence = "DROP SEQUENCE IF EXISTS %(sequence)s CASCADE"
sql_create_index = (