And if you want to see what ones are reserved, check here: gluon/reserved_sql_keywords.py
On Monday, October 8, 2012 12:49:00 PM UTC-7, Niphlod wrote: > > that's because probably you are using names that your db does not allow as > names because they are functions (i.e. naming a field "select" wouldn't > work on most of the dbs). > http://web2py.com/books/default/chapter/29/06#Reserved-keywords > > On Monday, October 8, 2012 9:42:33 PM UTC+2, VP wrote: >> >> I've always had this problem with web2py. Sometime, I got a weird name >> violation. For example, you can't name a table "order", or can't name a >> field "item". It doesn't seem to be documented anywhere. > > --

