[Pypgsql-devel] [ pypgsql-Support Requests-615598 ] Unintuitive error messages

[<no...@so...>]

Support Requests item #615598, was opened at 2002-09-27 17:48
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=216528&aid=615598&group_id=16528

Category: PgSQL.py
Group: None
Status: Open
Priority: 5
Submitted By: Wild Bill (wildbilly)
Assigned to: Nobody/Anonymous (nobody)
Summary: Unintuitive error messages

Initial Comment:
Hello,

My python code looks like this:

     cursor.execute("""INSERT INTO table1 VALUES(%s,
%s, %s, %s, %s, %s, %s)""", (iurl, tags2, val2, depth,
val3, val4, val5))

And the error message looks like this:

     libpq.OperationalError ERROR:  parser: parse error
at or near "l"

Which means absolutely nothing to me. I try some
debugging code to see what the SQL looks like:

     print """INSERT INTO able1 VALUES(%s, %s, %s, %s,
%s, %s, %s);""" % (iurl, tags2, val2, depth, val3,
val4, val5)

Which outputs

     INSERT INTO table1
VALUES(http://www.dmoz.org/Society/, 0, 3, 500, 50000,
200209271030, 0);

Any thoughts? Does PgSQL module take care of
backslashing, adding appropriate apostraphes, etc? I
can't find any documentation on this anywhere.

Thanks

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=216528&aid=615598&group_id=16528