Re: inserting blob data

I just wanted to chime in that I'm having the same problem, with basically
the same config.  In fact, I just joined this mailing list because of it.

-Jim Potts
----- Original Message -----
From: "Bruce Holt" <bj_holt@hotmail.com>
To: <tgl@sss.pgh.pa.us>
Cc: <pgsql-odbc@postgresql.org>
Sent: Wednesday, November 27, 2002 2:48 PM
Subject: Re: [ODBC] inserting blob data


> "Bruce Holt" <bj_holt@hotmail.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