On Sunday, July 22, 2018 at 10:28:46 PM UTC-7, Rahul wrote: > > Hey everyone, > Any clues on this one? OR should I start updating the > application and the models with unused field names? Please let me know > > > Does 'rname' help? You have to poke a bit in the book to find it at field level, but when you do it says
"rname provides the field was a "real name", a name for the field known to the database adapter; when the field is used, it is the rname value which is sent to the database. The web2py name for the field is then effectively an alias." <URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Field-constructor> See also <URL:https://groups.google.com/d/msg/web2py/X52AnJIQj_o/VnxIJcyNAwAJ> <URL:https://groups.google.com/d/msg/web2py/mVsTN7QLQ1M/QxaT3ObZAgAJ> /dps > On Friday, July 20, 2018 at 12:40:04 PM UTC+5:30, Rahul wrote: >> >> Hello All, >> I am migrating my project from SQLite to POSTGRESQL - >> I have a few field names and table names that seem to be a part of >> reserver/non-serverved POSTGRES keywords - For example, field name = *state >> (Field('state', .. )*, *Field('notify', 'boolean', label='Add >> Notification?', ), * >> >> Now I get below errors as highlighted below >> >> >> *My question is *- Is there a work around to make these names work some >> how ? (backticks or something I found on the web but how do I use it under >> DAL ? ) Also, I could not find anything about *rname* in the web2py >> documentation.. Any idea if / how it can help in this case ? >> >> *Ironically - * >> >> Initially I had db= ... check_reserved=['all'] and it never gave me the >> exception in SQLite but as soon as I switched it started giving me this. >> which I believe it shoudl have shown me even when I ws in SQLite. Is that >> an issue ? >> >> *<type 'exceptions.SyntaxError'> invalid table/column name "state" is a >> "ALL" reserved SQL/NOSQL keyword* >> >> & when I added >> >> *check_reserved=['postgres', 'postgres_nonreserved'**]* and now it is >> showing this error (Which is to the point) >> >> <type 'exceptions.SyntaxError'> invalid table/column name "state" is a >> "POSTGRES_NONRESERVED" reserved SQL/NOSQL keyword >> >> >> Please suggest how I can get rid of this issue >> >> Rahul >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.