Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: Dave PageDate: 2002-11-25 19:41:28
Subject: Re: inserting blob data
Previous:From: Bruce HoltDate: 2002-11-25 17:54:53
Subject: inserting blob data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group