I'm using Postgresql, with the pg8000 adapter.
One of the fields I have is of 'json' type
Field('json_string','json'),
And each time I restart the web2py server, this error will show one time.
Refreshing the page the second time makes it go away:
ProgrammingError: (u'ERROR', u'ERROR', u'42804', u'column "json_string__tmp" is
of type json but expression is of type text', u'You will need to rewrite or
cast the expression.', u'48', u'parse_target.c', u'540',
u'transformAssignedExpr', u'', u'')
I checked the db itself and the schema says:
Column = json_string
Type = text
So I did a search and manually altered the type to JSON. After restart, no
errors! It was good.
BUT... subsequent restarting of the server brought back the error. So I
checked the db again and the Type is changed back to 'text' again
--
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.
