From: | maplabs(at)light42(dot)com |
---|---|
To: | psycopg(at)postgresql(dot)org, Gustavo <gmpuljak(at)yahoo(dot)com(dot)ar> |
Subject: | Re: Error in a simple query |
Date: | 2013-06-24 23:06:48 |
Message-ID: | 20130624160648.cz07ta79moskwows@webmail.light42.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
the error might be in a line above..
try increasing the log verbosity and look again..
(I also use psycopg2 for PostGIS, not an issue in itself)
--
Brian M Hamlin
OSGeo California Chapter
On Mon, 24 Jun 2013 19:55:41 -0300, Gustavo <gmpuljak(at)yahoo(dot)com(dot)ar> 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?
> 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.”
>
>
> -- Sent via psycopg mailing list (psycopg(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/psycopg
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavo | 2013-06-24 23:18:55 | Re: Error in a simple query (SOLVED) |
Previous Message | Adrian Klaver | 2013-06-24 23:04:46 | Re: Error in a simple query |