[sqlalchemy] ORM insert: How to insert into a table with Identity column in Redshift database.

2018-12-09 Thread Ved Bhatnagar
Hi, How can I use ORM insert (session.add(object)) to insert values in a table with identity column in redshift database? Regards, Ved -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal,

[sqlalchemy] Redshift orm insert without passing auto generated primary key

2018-12-09 Thread Ved Bhatnagar
Hi, I am getting seq table error, when trying to use orm insert on redshift table with identity column. Can some point me to a solution? Regards, Ved -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an