Re: [sqlalchemy] Incorrect SQL generated for INSERT into PostgreSQL

2011-09-26 Thread Nathan Robertson
On Mon, Sep 26, 2011 at 11:05 PM, Michael Bayer wrote: > On Sep 26, 2011, at 2:50 AM, Nathan Robertson wrote: > >>       Column('custid', Integer, Sequence('test.customer_custid_seq'), >> primary_key=True), > > for the Sequence, as with all s

Re: [sqlalchemy] Incorrect SQL generated for INSERT into PostgreSQL

2011-09-26 Thread Nathan Robertson
On Mon, Sep 26, 2011 at 11:05 PM, Michael Bayer wrote: > On Sep 26, 2011, at 2:50 AM, Nathan Robertson wrote: > >>       Column('custid', Integer, Sequence('test.customer_custid_seq'), >> primary_key=True), > > for the Sequence, as with all s

[sqlalchemy] Incorrect SQL generated for INSERT into PostgreSQL

2011-09-26 Thread Nathan Robertson
Hi, I've come across a bug (hopefully in my configuration) where SQLAlchemy will generate an INSERT statement for a table with a SERIAL primary key which PostgreSQL errors on. I'm running EnterpriseDB's Postgres Plus 8.4 on openSUSE 11.4 x64, with Python 2.7, SQLAlchemy 0.7.2 and psycopg2 2.4.2. F