On 8/29/15 7:51 PM, Demitri Muna wrote:
Hi Michael,
On Friday, August 28, 2015 at 11:54:17 AM UTC-4, Michael Bayer wrote:
this log shows clearly that the second query is not returning any
rows at the DBAPI driver level - you can see that unlike the first
query, there is no "Row" logged. The query you want to run on your
database would be using plate_id 8636 and you want to make sure
the JOIN is there also:
That's the query I retrieved from the "echo" before. When entered
into psql, it returns the (single) row I'm looking for. Hence the
perplexity. I take it then this is a psycopg2 problem then?
if it happens every time with that exact same numeric identifier, that's
a clue. If it happens on more than just one particular Postgresql
database server with the same data, that's another clue.
You'd want to construct a raw psycopg2 script and test that the query
using the same string SQL and the same parameter passed to
cursor.execute() still isn't working.
Strange about the duplicate post; I originally sent it via email. When
it didn't appear on the list (or the web site), I resent via the web
interface. I seem to have this problem with all my Google Groups posts...
Thanks,
Demitri
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
