[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-04 Thread Michael Bayer
On Oct 3, 2009, at 5:18 PM, volx wrote: Hi Mike: Thank you for that. I will try it out on Monday. I see there is a major refactoring around types in version 0.6. One would be expected to define table classes with generic SQL types like CHAR or generic language types like String and not

[sqlalchemy] Strange ObjectDeletedError

2009-10-04 Thread Y3s
Hi all, I'm getting an unexpected ObjectDeletedError. The following code shows the problem (on SA 0.5.6, with both sqlite and postgresql): from sqlalchemy import * from sqlalchemy import orm # Usual stuff... m = MetaData() t = Table(test, m, Column(id, Integer, primary_key=True),

[sqlalchemy] Re: Strange ObjectDeletedError

2009-10-04 Thread Michael Bayer
On Oct 4, 2009, at 7:54 PM, Y3s wrote: Session = orm.sessionmaker(autocommit=True, autoflush=False) you're using non-default session settings, all attributes are expired upon transaction commit which in this case due to autocommit makes the object unreachable within the flush, so set