From: | Nils Gösche <cartan(at)cartan(dot)de> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Empty bytea values on 9.2.1 |
Date: | 2012-10-29 17:58:14 |
Message-ID: | 006a01cdb5fe$f8400c00$e8c02400$@de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi!
On an 8.4 installation, I have a table with a bytea column. In some rows, the
value of this column has length 0. When I query that table with a normal SELECT,
using the ODBC driver from C#, I get a byte[] object of length 0 on those rows.
So far so good.
Now, I dumped the database and restored it on a 9.2.1 installation. The tables
look the same on the new installation: Zero length of the bytea values in some
columns. However, if I try to retrieve such rows with the exact same program as
above, with the same ODBC driver, same connection string except the host name,
suddenly I get a byte[] object of length 1! And the one byte in that array
appears to be random!
At first, I thought it might be a Postgres bug. I wrote a simple program that
uses Npgsql to retrieve those rows, however, the behavior wasn't reproducible
anymore that way. It occurs only if I use ODBC. So, I suspect there is something
in the ODBC driver causing this.
Can anybody else confirm this?
Regards,
--
Nils Gösche
"Don't ask for whom the <CTRL-G> tolls."
From | Date | Subject | |
---|---|---|---|
Next Message | Nils Gösche | 2012-10-29 18:01:42 | Re: PostgreSQL driver not visible in windows control panel |
Previous Message | Fred Parkinson | 2012-10-29 17:50:49 | PostgreSQL driver not visible in windows control panel |