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.
