Re: [sqlalchemy] Inserting new records table with serial primary key in Postgresql using ORM

2011-08-26 Thread Michael Bayer
Sorry, once more, using the SERIAL value in an autoincrementing fashion instead of the 0. Also works without issue. On Aug 26, 2011, at 11:20 PM, Michael Bayer wrote: > Theres no apparent issue with your code, a completed version working > correctly is attached - I only needed to create

Re: [sqlalchemy] Inserting new records table with serial primary key in Postgresql using ORM

2011-08-26 Thread Michael Bayer
Theres no apparent issue with your code, a completed version working correctly is attached - I only needed to create Entry. Start with the attached script, using a new, blank database since it drops the tables, and work backwards towards the identical situation as your failing code to identify

[sqlalchemy] Inserting new records table with serial primary key in Postgresql using ORM

2011-08-26 Thread dfreedman
Very basic scenario that I've been struggling with. I have a table called "Entries" in Postgresql with a primary key of type Serial call "id". I'm using ORM reflection to map my classes to underlying tables. I'm then populating my Entry instance and submitting it for Insert via session.merge, se