On Thu, Mar 28, 2013 at 4:34 PM, Don Parris <parrisdc@gmail.com> wrote:
> Thanks Daniele,
>
> I'm using psycopg 2.4.5 with Python 3.2.3 on Kubuntu 12.10.
>
> This is the connection encoding based on a quick check at the Python
> console:
>>>>print(con.encoding)
> SQLASCII
In this case it's natural that you get an error on decode. But is it
really the database encoding? What does this query say:
cur = con.cursor()
cur.execute("show client_encoding")
print cur.fetchone()[0]
> I honestly don't know where the error actually is - not a very advanced
> programmer by any means. All I really know is that the program breaks when
> I use fetchall(), but it works with fetchone() and fetchmany(). It could
> have something to do with the way my main program module imports the module
> that calls the function, for all I know. Here is the traceback:
I'll try to load your dataset and play with it, thank you.
-- Daniele