Jonathan, Thank you for your time and reply, but that still does not work for me. Even after adding the object to the session and flush()ing, its id is still None.
Thanks, Mike ________________________________ From: sqlalchemy@googlegroups.com [sqlalchemy@googlegroups.com] on behalf of Jonathan Vanasco [jonat...@findmeon.com] Sent: Wednesday, November 06, 2013 2:01 PM To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] Re: "Immediate" access to value of a new object's Sequence primary key column? You missed adding the object to the session, before the flush. this should work: new_foo = Foo('red') dbSession.add(new_foo) dbSession.flush() print new_foo.id -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.