Re: inserting blob data

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: inserting blob data
Date: 2002-11-25 18:41:35
Message-ID: 8847.1038249695@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

"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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-11-25 19:41:28 Re: inserting blob data
Previous Message Bruce Holt 2002-11-25 17:54:53 inserting blob data