Re: Problems with insert

Adriano Monteiro said the following on 11/25/2004 01:02 PM:
> I'm having some trobles with INSERT and psycopg...
> I don't know why it doesn't work.
>
> My code:
>
>                 sql = "INSERT INTO operario ( operario_id, nome,
> status, secao ) VALUES ( '3',  'Test', 'ATIVO', 'ENCASTOAMENTO' )"
>                 cursor_insert = self.conexao.cursor()
>                 cursor_insert.execute ( sql )
>                 cursor_insert.commit ()
>
> And I got the error:
>
> Traceback (most recent call last):
>   File "producao/python/operario.py", line 159, in adicionar
>     cursor_insert.commit (  )
> psycopg.Error: serialized connection: cannot commit on this cursor
>
> Does anyone know how to explain what I'm doing wrong?
Take a look at the README and search for `Extensions to the Python 
DBAPI-2.0`. You may only commit a cursor if you chose to "deserialize" 
your cursors.
Regards
Mirko
--