Re: Problems

Il giorno gio, 12/05/2005 alle 00.53 +0200, charlie clark ha scritto:
> Dear list,
> 
> currently having all kinds of problems converting some text files to 
> databases. This is from psycopg2 (1.99.13) with Python 2.3 on Windows 2000 
> talking to PostgreSQL 8.0 on Windows.
> 
> pq_execute: executing SYNC query:
>      SELECT id FROM localekit_attributes WHERE attribute = 'We hope that 
> nobody h
> as been forgotten here. Regards,
> CEO/CVO Bernd Korz
> CTO Alan Westbrook.'
> pq_execute: entering syncronous DBAPI compatibility mode
> pq_fetch: pgstatus = PGRES_FATAL_ERROR
> pq_fetch: uh-oh, something FAILED
> pq_fetch: fetching done; check for critical errors
> psyco_curs_execute: res = -1, pgres = 00000000
> Traceback (most recent call last):
>    File "locale_insert.py", line 131, in ?
>      do_insert(lc)
>    File "locale_insert.py", line 71, in do_insert
>      c.execute(attribute, (attr, ))
> psycopg.ProgrammingError: current transaction is aborted, commands ignored 
> until
>   end of transaction block

PostgreSQL is telling you that a previous query failed and executing
more queries in the current transaction will just raise more errors. You
need to rollback() on the connection object before going on.
 
-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                
fog-8fiUuRrzOP0dnm+yROfE0A@xxxxxxxxxxxxxxxx
INIT.D Developer                                           
fog-NGVKUo/i/6DYtjvyW6yDsg@xxxxxxxxxxxxxxxx
              La felicità è una tazza di cioccolata calda. Sempre. -- Io

signature.asc
Description: This is a digitally signed message part

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg