From 52672a64cc0cab4ea14a4a756fce850eb03315e3 Mon Sep 17 00:00:00 2001 From: Jim Rollenhagen Date: Thu, 26 Sep 2019 09:56:42 -0400 Subject: Retire github mirror, repo moved to opendev --- doc/source/faq.rst | 13 ------------- 1 file changed, 13 deletions(-) delete mode 100644 doc/source/faq.rst (limited to 'doc/source/faq.rst') diff --git a/doc/source/faq.rst b/doc/source/faq.rst deleted file mode 100644 index ba250bc..0000000 --- a/doc/source/faq.rst +++ /dev/null @@ -1,13 +0,0 @@ -FAQ -=== - -Q: Adding a **nullable=False** column -************************************** - -A: Your table probably already contains data. That means if you add column, it's contents will be NULL. -Thus adding NOT NULL column restriction will trigger IntegrityError on database level. - -You have basically two options: - -#. Add the column with a default value and then, after it is created, remove the default value property. This does not work for column types that do not allow default values at all (such as 'text' and 'blob' on MySQL). -#. Add the column without NOT NULL so all rows get a NULL value, UPDATE the column to set a value for all rows, then add the NOT NULL property to the column. This works for all column types. -- cgit v1.2.1