After switching to psycopg2 I still run into the same errors. However,
after I updated to 2.15.1 (after Massimo's announcement on the groups), it
now works.
On Tuesday, July 11, 2017 at 9:44:19 PM UTC+8, Leonel Câmara wrote:
>
> pydal uses text for json fields if you're using pg8000 because pg80
pydal uses text for json fields if you're using pg8000 because pg8000
didn't use to support json. If you change to psicopg2 you need to convert
the field manually as you did and then use psicopg2 consistently.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://g
Please open a pydal issue so we can track this.
On Wednesday, 5 July 2017 15:49:14 UTC-5, Massimo Di Pierro wrote:
>
> what do you mean by " manually altered the type to JSON"? Anyway, please
> use psycopg2 instead of pg8000.
>
> On Tuesday, 4 July 2017 04:03:00 UTC-5, lyn2py wrote:
>>
>> I'm usi
In addition, I have installed and using psycopg2 driver.
I still run into the error:
(column "json_string__tmp" is of type
json but expression is of type text
LINE 1: UPDATE "data_table" SET "json_string__tmp"="json_string"...
^
HINT: You w
>
> what do you mean by " manually altered the type to JSON"?
I meant that I logged into the Postgresql DB and ran a command to cast the
right type, i.e. "json", for that particular column.
On Thursday, July 6, 2017 at 4:49:14 AM UTC+8, Massimo Di Pierro wrote:
>
> what do you mean by " man
what do you mean by " manually altered the type to JSON"? Anyway, please
use psycopg2 instead of pg8000.
On Tuesday, 4 July 2017 04:03:00 UTC-5, lyn2py wrote:
>
> I'm using Postgresql, with the pg8000 adapter.
>
> One of the fields I have is of 'json' type
>
> Field('json_string','json'),
6 matches
Mail list logo
