Hi,
I am working with an existing database (MySQL - Prestashop).
On some tables, auto-incrementation for primary key is not used. And I am not able to set it, because it goes against the logic of the application. I know, wired, but...

Is it possible to force SQLObject to insert id manually?

PsMessageReaded(id = myId, idEmployee=3, dateAdd =  tStamp)

When I am trying it, I am getting following error:

    self._executeRetry(conn, c, q)
  File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/mysql/mysqlconnection.py", line 129, in _executeRetry
    raise ProgrammingError(ErrorMessage(e))
sqlobject.dberrors.ProgrammingError: Column 'id_message' specified twice



id_message is the name of the primary key column in the table:

class PsMessageReaded(SQLObject):
    _connection = connection
    class sqlmeta:       
        idName = 'id_message'
        fromDatabase = True

Thanks for your comments

Petr Jakes