I was seeing errors like this:
The full error: ERROR: syntax error at or near "group" at character 99
CREATE TABLE "my_table" (
"id" serial NOT NULL PRIMARY KEY,
"group" smallint CHECK (group >= 0) NOT NULL,
);
so I made this change:
Index: core/db/backends/postgresql.py
===================================================================
--- core/db/backends/postgresql.py (revision 1569)
+++ core/db/backends/postgresql.py (working copy)
@@ -174,8 +174,8 @@
'NullBooleanField': 'boolean',
'OneToOneField': 'integer',
'PhoneNumberField': 'varchar(20)',
- 'PositiveIntegerField': 'integer CHECK (%(column)s >= 0)',
- 'PositiveSmallIntegerField': 'smallint CHECK (%(column)s >= 0)',
+ 'PositiveIntegerField': 'integer CHECK ("%(column)s" >= 0)',
+ 'PositiveSmallIntegerField': 'smallint CHECK ("%(column)s" >= 0)',
'SlugField': 'varchar(50)',
'SmallIntegerField': 'smallint',
'TextField': 'text',
and then everything worked fine.
