I'm using a dictionary interpolated string to create a query statement.
When I generate the query by hand sql =3D query % params
and execute the sql from inside psql, it works.
when i create cursor and use cursor.execute(query,params)
i get the following traceback
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/tmp/python-5481BIu.py", line 134, in insert_title
File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3048,
in execute
self.res =3D self.conn.conn.query(_qstr % parms)
TypeError: float argument required
line 3048 seems to be where the Exception is handled, but the
'self.res =3D ...' line occurs in method callproc, and I don't see where
it gets called from inside the method execute.
the only oddball column is one that is of type numeric(9,2)
do I need to wrap this in PgNumeric before I hand the dictionary to execute
Or is there something deepr going on?
--=20
http://Zoneverte.org -- information explained
Do you know what your IT infrastructure does?
|
