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@sss.pgh.pa.us>
To: "Bruce Holt" <bj_holt@hotmail.com>
CC: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] inserting blob data
Date: Mon, 25 Nov 2002 13:41:35 -0500
"Bruce Holt" <bj_holt@hotmail.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