[sqlalchemy] Postgres: autoincremet sequence do not work after upgrade to sql 7.2

2011-09-03 Thread robert rottermann
Hi there, after Upgrading sqlalchemy to V 0.7.x i get the following error Traceback (innermost last): Module ZPublisher.Publish, line 126, in publish Module ZPublisher.mapply, line 77, in mapply Module ZPublisher.Publish, line 46, in call_object Module wrapper, line 5, in wrapper

Re: [sqlalchemy] Postgres: autoincremet sequence do not work after upgrade to sql 7.2

2011-09-03 Thread Michael Bayer
1. How is the Table metadata defined here (reflection? Or Integer primary key autoincrement left at its default value of True?) Exact code would be helpful here if you're not sure. 2. What does the SQL echo output say? You should see a SELECT that is specific to the sequence on the table in

Re: [sqlalchemy] Postgres: autoincremet sequence do not work after upgrade to sql 7.2

2011-09-03 Thread Michael Bayer
additional q: 1. upgrading to 0.7 from0.6 ? 0.5 ? 0.6 was where a major change to autoincrement behavior was made re: postgresql 2. Any difference in psycopg2 version on prod server vs. dev ? On Sep 3, 2011, at 6:07 PM, Michael Bayer wrote: 1. How is the Table metadata defined here

Re: [sqlalchemy] Postgres: autoincremet sequence do not work after upgrade to sql 7.2

2011-09-03 Thread Michael Bayer
Yes, my research suggests specifically that it's likely you have autoincrement=False on the Column in question, or that you aren't using an Integer type - such as String or Float, on the primary key column in question. The error below corresponds to when the sequence fires normally, the row