On 07/30/2014 05:59 AM, 'Frank Liou' via sqlalchemy wrote: > > HI! Jonathan > > > I use self.trans = self.connection.begin() > > but > > now i use debug lock before commit
I'm afraid I don't know what that means. > > then i try to use my pgAdmin to add or update same data. At least that implies that you're using PostgreSQL. I don't think you'd mentioned with RDBMS you're using. > > and then > > it's sussesful to add data by pgAdmin > > i think that meaning my trans did not work > > and it maybe just can lock the same client or same code > > but it can't lock another client Again, I'm not really sure what you mean. > > by the way > > my isolation_levelset > > self.engine = create_engine(Database.get_db_connection_string(), > isolation_level="SERIALIZABLE", echo=True) > > > can you give me some guide to fix this problem? The best documentation I'm aware of is the official PostgreSQL documentation: <URL:http://www.postgresql.org/docs/9.3/static/transaction-iso.html> -- Jonathan Rogers -- 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/d/optout.