Re: Error in a simple query (SOLVED)

Adrian,

thanks for the hint. The script was processing data from a txt file with
several thousand lines and the problem was in a malformed insert from the
bottom of the previous iteration.
Thanks.

On Lun 24 Jun 2013 20:04:46 Adrian Klaver escribió:
> On 06/24/2013 03:55 PM, Gustavo wrote:
> > Hi,
> >
> > I'm using psycopg2 extensively in different scripts to process spatial
> > data with postgresql 9.1 and postgis. However, in one script I have the
> > following error:
> >
> > psycopg2.internalerror: current transaction is aborted, commands ignored
> > until end of transaction block
> >
> > The command that gave the error is:
> >
> > a = """select idbalizas from nuevo.balizas where %s %s %s %s""" % (emp1,
> > dnid1, mem1, mmsi1)
> > print
> > cur.execute(a)
> >
> > One example of 'a' is:
> >
> > select idbalizas from nuevo.balizas where emp='005' and dnid='08466'
> > and mem='055' and mmsi='701000535'
> >
> > I can run this same query in psql and other postgresql clients and it
> > returns the correct answer.
> >
> > Can you help me debugging this?
>
> What shows up in the Postgres log?
>
> > Many thanks.

--
Gustavo Martínez
Skype: gmpuljak
Linkedin: http://ar.linkedin.com/in/gustavomartínezpuljak

“Que la tierra se vaya haciendo camino ante tus pasos,
que el viento sople siempre a tus espaldas,
que el sol brille cálido sobre tu cara,
que la lluvia caiga suavemente sobre tus campos y,
hasta tanto volvamos a encontrarnos,
que Dios te lleve en la palma de su mano.”