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

2011-09-27 Thread Michael Bayer
On Sep 27, 2011, at 1:12 AM, Nathan Robertson wrote: 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 schema

[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.

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

2011-09-26 Thread Michael Bayer
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 schema items, you need to specify the schema portion separately so that SQLAlchemy knows where each token starts and

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 mike...@zzzcomputing.com 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 schema items, you need to specify the

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 schema items, you need to specify the schema portion