id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
1032	column names unquoted in postgres backend CHECK expressions	exoweb adrian	Adrian Holovaty	"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."	defect	closed	Database layer (models, ORM)		normal	fixed			Unreviewed	0	0	0	0	0	0