Advertisement
kaiw

SQLAlchemy Enum Bug Output

Nov 30th, 2013
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.75 KB | None | 0 0
  1. Traceback (most recent call last):
  2. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
  3. context)
  4. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/default.py", line 326, in do_execute
  5. cursor.execute(statement, parameters)
  6. psycopg2.ProgrammingError: syntax error at or near "s"
  7. LINE 1: ...TYPE committee_position AS ENUM ('President','Men's Captain'...
  8. ^
  9.  
  10.  
  11. The above exception was the direct cause of the following exception:
  12.  
  13. Traceback (most recent call last):
  14. File "test.py", line 16, in <module>
  15. Base.metadata.create_all(engine)
  16. File "/usr/lib64/python3.2/site-packages/sqlalchemy/schema.py", line 2796, in create_all
  17. tables=tables)
  18. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 1479, in _run_visitor
  19. conn._run_visitor(visitorcallable, element, **kwargs)
  20. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 1122, in _run_visitor
  21. **kwargs).traverse_single(element)
  22. File "/usr/lib64/python3.2/site-packages/sqlalchemy/sql/visitors.py", line 109, in traverse_single
  23. return meth(obj, **kw)
  24. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/ddl.py", line 70, in visit_metadata
  25. self.traverse_single(table, create_ok=True)
  26. File "/usr/lib64/python3.2/site-packages/sqlalchemy/sql/visitors.py", line 109, in traverse_single
  27. return meth(obj, **kw)
  28. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/ddl.py", line 83, in visit_table
  29. _ddl_runner=self)
  30. File "/usr/lib64/python3.2/site-packages/sqlalchemy/event.py", line 407, in __call__
  31. fn(*args, **kw)
  32. File "/usr/lib64/python3.2/site-packages/sqlalchemy/util/langhelpers.py", line 407, in __call__
  33. return getattr(self.target, self.name)(*arg, **kw)
  34. File "/usr/lib64/python3.2/site-packages/sqlalchemy/types.py", line 1937, in _on_table_create
  35. t._on_table_create(target, bind, **kw)
  36. File "/usr/lib64/python3.2/site-packages/sqlalchemy/dialects/postgresql/base.py", line 870, in _on_table_create
  37. self.create(bind=bind, checkfirst=checkfirst)
  38. File "/usr/lib64/python3.2/site-packages/sqlalchemy/dialects/postgresql/base.py", line 821, in create
  39. bind.execute(CreateEnumType(self))
  40. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 662, in execute
  41. params)
  42. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 720, in _execute_ddl
  43. compiled
  44. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
  45. context)
  46. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
  47. exc_info
  48. File "/usr/lib64/python3.2/site-packages/sqlalchemy/util/compat.py", line 187, in raise_from_cause
  49. reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  50. File "/usr/lib64/python3.2/site-packages/sqlalchemy/util/compat.py", line 182, in reraise
  51. raise value.with_traceback(tb)
  52. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
  53. context)
  54. File "/usr/lib64/python3.2/site-packages/sqlalchemy/engine/default.py", line 326, in do_execute
  55. cursor.execute(statement, parameters)
  56. sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or near "s"
  57. LINE 1: ...TYPE committee_position AS ENUM ('President','Men's Captain'...
  58. ^
  59. "CREATE TYPE committee_position AS ENUM ('President','Men's Captain')" {}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement