Re: inserting blob data

"Bruce Holt" <bj_holt(at)hotmail(dot)com> writes:
>> Hmm, the 8K limit has been gone for a long time. You didn't mention
>> your Postgres server's version, but I'm betting you need to update
>> either your server or your ODBC driver. Possibly both.

> PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2

>And your ODBC driver was up to date too, right? So much for that
>theory. How exactly are you trying to store the blob data? (A code
>snippet would be an appropriate answer, probably.)

I am using the ADO for VB example found at:
http://odbc.postgresql.org/psqlodbc.php?DocID=howto-vblo

I have tried three table structures as well:

# create table MYTABLE (main integer, object bytea);
# create table MYTABLE (main integer, object oid);
# create table MYTABLE (main integer, object text);

I can insert the data correctly, and save it to the server using the
# select lo_export(#####, '/mypath/myfile');
command. I just can't retrieve the blob data via ODBC.

Thanks,
Bruce Holt

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963