Hello, Firstly, thank you to all who replied to me about postgresql PGBigInteger - I now have some test code which generates the SQL to create a postgresql table with types of bigint, so that is one scaling issue I know is covered.
My question: I have been working through the tutorial at http://elixir.ematia.de/trac/wiki/TutorialDivingIn . I am doing the tutorial exactly as it is written with sqlite. My problem is that when I get to the first session.commit() I get this traceback - is there possibly some step missing in the tutorial?: In [5]: session.commit() --------------------------------------------------------------------------- InvalidRequestError Traceback (most recent call last) /home/reesb/urwid/<ipython console> in <module>() /var/lib/python-support/python2.5/sqlalchemy/orm/scoping.pyc in do(self, *args, **kwargs) 96 def instrument(name): 97 def do(self, *args, **kwargs): ---> 98 return getattr(self.registry(), name)(*args, **kwargs) 99 return do 100 for meth in ('get', 'load', 'close', 'save', 'commit', 'update', 'save_or_update', 'flush', 'query', 'delete', 'merge', 'clear', 'refresh', 'expire', 'expunge', 'rollback', 'begin', 'begin_nested', 'connection', 'execute', 'scalar', 'get_bind', 'is_modified', '__contains__', '__iter__'): /var/lib/python-support/python2.5/sqlalchemy/orm/session.pyc in commit(self) 550 self.begin() 551 else: --> 552 raise exceptions.InvalidRequestError("No transaction is begun.") 553 554 self.transaction.commit() InvalidRequestError: No transaction is begun. Thanks, Brett -- You received this message because you are subscribed to the Google Groups "SQLElixir" 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/sqlelixir?hl=en.
