Re: "invalid input syntax for type bytea"

On 08/31/11 9:02 AM, Alan Millington wrote:
> I am running Postgres 8.4.1 on Windows XP Pro...

8.4 is currently up to 8.4.8 and you really should upgrade. 8.4.1 is
about 2 years old, and there's a long list of bugs fixed in the later
8.4 updates, see the release notes for 8.4.2 through 8.4.8 for the gory
details,
http://www.postgresql.org/docs/8.4/static/release.html

Any particular reason you're using ODBC and not a PostgreSQL python
binding like Psycopg ? I find the more layers of abstraction between
your code and the outside world, the more obscure the bugs are, and the
harder they are to track down.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast