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@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