| From: | Gustavo <gmpuljak(at)yahoo(dot)com(dot)ar> |
|---|---|
| To: | psycopg(at)postgresql(dot)org |
| Subject: | Error in a simple query |
| Date: | 2013-06-24 22:55:41 |
| Message-ID: | 201306241955.41267.gmpuljak@yahoo.com.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
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?
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.”
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-06-24 23:04:46 | Re: Error in a simple query |
| Previous Message | Daniele Varrazzo | 2013-06-23 19:50:06 | Psycopg 2.5.1 released |