Hi,
I don't know if this error is CatWalk specific, but I get it in
CatWalk when adding a record.
Environment: TG rev. 506 + Postgres 7.4 + Python 2.4, brand new
quickstart project with only dburi and model modified.
2006/01/11 20:09:20 HTTP INFO 127.0.0.1 - POST /catwalk/add HTTP/1.1
2006/01/11 20:09:20 INFO Traceback (most recent call last):
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/CherryPy-2.1.1-py2.4.egg/cherrypy/_cphttptools.py",
line 271, in run
main()
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/CherryPy-2.1.1-py2.4.egg/cherrypy/_cphttptools.py",
line 502, in main
body = page_handler(*args, **cherrypy.request.paramMap)
File "/Users/ksenia/www/3rdparty/tg/turbogears/controllers.py", line
240, in newfunc
html, fragment, *args, **kw)
File "/Users/ksenia/www/3rdparty/tg/turbogears/database.py", line
189, in run_with_transaction
retval = func(*args, **kw)
File "/Users/ksenia/www/3rdparty/tg/turbogears/controllers.py", line
257, in _execute_func
output = func(self, *args, **kw)
File "/Users/ksenia/www/3rdparty/tg/turbogears/toolbox/catwalk/__init__.py",
line 758, in add
new_object = obj(**params)
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/main.py",
line 1197, in __init__
self._create(id, **kw)
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/main.py",
line 1224, in _create
self._SO_finishCreate(id)
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/main.py",
line 1248, in _SO_finishCreate
id, names, values)
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/dbconnection.py",
line 752, in queryInsertID
return self._dbConnection._queryInsertID(
File
"/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/postgres/pgconnection.py",
line 122, in _queryInsertID
c.execute("SELECT NEXTVAL('%s')" % sequenceName)
ProgrammingError: ERROR: current transaction is aborted, commands
ignored until end of transaction block
SELECT NEXTVAL('news_id_seq')
--
Ksenia
