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
Thank you,
*Rahul*
--------------------
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
