Formatting problem

Hi all,

 

I have a problem with calling the execute method with a query that has a formatting operator in it. If I perform the substitution before calling the execute method, everything works. Am I doing something wrong?

 

Thanks for the help!

Jozsef

 

Test case:

 

In psql:

 

Create table test_table (id integer);

Insert into test_table values (1);

Insert into test_table values (2);

 

Now in python (v2.3):

 

import psycopg2

con = psycopg2.connect(‘dbname=test user=test’)

cur  = con.cursor()

 

cur.execute(‘select id from test_table where id in (%(ids)s)’, {‘ids’:’1, 2’})

Traceback (most recent call last):

  File "<stdin>", line 1, in ?

psycopg2._psycopg.ProgrammingError: invalid input syntax for integer: "1, 2"

 

# notice that this error is reported by psycopg not postgres, no need to abort the transaction

cur.execute(‘select id from test_table where id in (1, 2)’)

print cur.rowcount

2

 

 

 

 

 

 

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg