Hi - Need to know exact version of postgresql server in use as well as that of psycopg2. Problem replicates with most up to date version of psycopg2 as well?
On Sun, Dec 2, 2018, 1:57 AM Nirmal .M <[email protected] wrote: > If I connect to my database directly using psycopg2 it works, However, if > I try with sqlalchemy it throws Programming error > > Direct connection using psycopg2 works: > connection = psycopg2.connect( > sslmode='require', > host='query-prod-va7', > port='80', > dbname='all', > user='262850A15A7B8AB', > password='XXXX') > print(connection.encoding) > cursor = connection.cursor() > cursor.execute("SELECT * FROM segmentation_demo_profiles LIMIT 10;") > rows = cursor.fetchall() > cursor.close() > pprint.pprint(rows) > > Over SQLAlchemy that fails > def getconn(): > return psycopg2.connect( > sslmode='require', > host='query-prod-va7', > port='80', > dbname='all', > user='262850A15A7B8AB', > password='XXXXX') > > engine = create_engine('postgresql+psycopg2://', creator=getconn) > engine.connect() > > ProgrammingError: (psycopg2.ProgrammingError) sessionId: > adf707f6-096f-4dd2-be71-883ca7a71a23 ErrorCode: 42601 Syntax error > encountered. Reason: [Invalid command!] > (Background on this error at: http://sqlalche.me/e/f405) > > Same issue if using a connection string. Attached stack trace. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
