On May 11, 2010, at 4:54 PM, Russell Posluszny wrote: > I'm currently working with SA 0.5.8 and running into an issue updating > a partitioned table in PostgreSQL, getting the following error: > > Updated rowcount 12 does not match number of objects updated 100 > > This seems to be a known issue, and I've found a discussion in the > archive from about 3 years ago discussing the possibility of a flag on > the Table or dialect-level flag to indicate supports_sane_rowcount = > False > > Were either of these approaches patched into a more recent version of > SQLAlchemy? If not, is there an elegant, or atleast a preferred way of > dealing with this situation?
this specific issue is mentioned with some less than ideal solutions at http://www.redhat.com/f/pdf/jbw/jmlodgenski_940_scaling_hibernate.pdf on slide 23. If their modification to the trigger doesn't work for you, turn off the sane rowcount feature: engine = create_engine(...) engine.dialect.supports_sane_rowcount = False -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
