[sqlalchemy] Re: Strange ObjectDeletedError

2009-10-05 Thread Y3s
On Oct 5, 4:59 am, Michael Bayer wrote: > 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 ca

[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: Problem with non-pk sequences in relations on MSSQL

2009-08-27 Thread Y3s
On Aug 27, 9:05 pm, "Michael Bayer" wrote: > Y3s wrote: > > > It seems that the child instances are not updated with the right > > sequence number. Moreover, if I turn the parent's "id" column into the > > primary key, the error disappears.

[sqlalchemy] Problem with non-pk sequences in relations on MSSQL

2009-08-27 Thread Y3s
Hi all, I'm having a problem with a non primary key sequence involved in a relation. The failing environment is sqlalchemy 0.5.5 on ms sql server 2005 with pymssql 0.8. I have a "parent" table with its own pk and a sequence field and a "child" table with a pk composed by the parent's sequence (NOT