Re: "ProgrammingError: can't adapt" when passing arguments to cursor.execute
Adrian Klaver <[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <[email protected]> |
On Friday 20 November 2009 8:51:16 am William Carithers wrote: > Hi Adrian, > > Thanks. I was worried about exactly that problem such as trying to load a > boolean into a column expecting a real. So I literally cut and pasted the > values from the "load" list in the script editor into the "load" list in > the interactive session. It worked in one case and not in the other. I'm > not sure why there is a roundoff difference but as long as values are > consistent about data types, I would think that it would be OK but at this > point my confidence level is pretty low. > > Cheers, > Bill > Would be possible to see the schema for the table involved? Also maybe try to walk through the INSERT values in the script to see if can isolate the problem? -- Adrian Klaver [email protected]