Re: inserting blob data

grouplink=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
(1 row)

Thanks,
Bruce Holt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bruce Holt" <bj_holt(at)hotmail(dot)com>
CC: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] inserting blob data
Date: Mon, 25 Nov 2002 13:41:35 -0500

"Bruce Holt" <bj_holt(at)hotmail(dot)com> writes:
> I am new to PostgreSQL (running on Red Hat 8.0) and the ODBC driver for
> Windows (version 7.0.2.003). I need to store binary data (up to 10 MB)
in
> a table. I have tried to insert my data, and have been successful up to
8kb
> of data (which is my block size). How can I store data that exceeds my
> block size limitation?

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.

regards, tom lane

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail