Re: [web2py] Error using Postgres

PROBLEM SOLVED [image: http://itjp.net.br] http://itjp.net.b r *Ovidio Marinho Falcao Neto* ovidio...@gmail.com Brasil 2018-02-28 8:02 GMT-03:00 Morganti

Re: [web2py] Error using Postgres

Hi, The last command before the error in line 54 'for row in rows:' is a selection using 'iterselect'. I changed the 'iterselect' to 'select' and no more errors. Thanks Massimo, Ovidio and Daves. Best regards André Em terça-feira, 27 de fevereiro de 2018 12:29:16 UTC-3, Morganti escreveu: >

Re: [web2py] Error using Postgres

HI Massimo, I could import psycopg2 in web2py shell manually. I used the installation script inside web2py scripts folder. Bellow the entire error: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File

Re: [web2py] Error using Postgres

If it finds psycopg2 it should be using it over pg8000. Is t possible you have two versions of python installed? On Sunday, 25 February 2018 04:46:57 UTC-6, Morganti wrote: > > Hi Massimo, thanks your answer. > > How can force web2py uses psycop2? I install pyscop2 using pip and made a > test

Re: [web2py] Error using Postgres

Hi Massimo, thanks your answer. How can force web2py uses psycop2? I install pyscop2 using pip and made a test importing it in normal python shell. But I got the same error when tried to execute the same function: ((u'ERROR', u'34000', u'portal "pg8000_portal_294" does not exist',

Re: [web2py] Error using Postgres

I know. It is there and we distribute it but we will remove it in the next version. I run into lots of problems with it, even with simple apps. psycopg2 works instead. On Friday, 23 February 2018 04:57:41 UTC-6, Morganti wrote: > > Hi Dave, > > I found "pg8000" inside "gluon/contrib". > > In

Re: [web2py] Error using Postgres

Hi Dave, I found "pg8000" inside "gluon/contrib". In "gluon\packages\dal\pydal\adapters" I found the "postgres.py". So is it wrong? Do I need to move pg8000 to "gluon\packages\dal\pydal\adapters"? You said about socket. I have no idea how to do it. Thanks a lot your support! Best regards

Re: [web2py] Error using Postgres

On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote: > > Hi, thanks your time. > > How can I check it? If I try to open web2py shell (web2py -S app -M), I > had no errors and all tables could be used. > > Thanks > BR > André > > That's one way to check. The actual files should

Re: [web2py] Error using Postgres

Hi, thanks your time. How can I check it? If I try to open web2py shell (web2py -S app -M), I had no errors and all tables could be used. Thanks BR André Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio Marinho escreveu: > > make sure the pg8000 and psycopg2 libraries are

Re: [web2py] Error using Postgres

make sure the pg8000 and psycopg2 libraries are installed at the start of web2py [image: http://itjp.net.br] http://itjp.net.b r *Ovidio Marinho Falcao Neto* ovidio...@gmail.com

[web2py] Error using Postgres

Hello, I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1. I tried to execute one controller that populate some tables and got the error below. Then, I used that command to create a csv file with all tables and uploaded it in my desktop using SQLITE and no error were found.