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

Re: inserting blob data

From: "Bruce Holt" <bj_holt(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: inserting blob data
Date: 2002-11-26 21:52:52
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
grouplink=# select 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)

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   I need to store binary data (up to 10 MB) 
 > a table.  I have tried to insert my data, and have been successful up to 
 > 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*


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-11-27 01:09:58
Subject: Re: psqlodbc-7.2.4 problem
Previous:From: Dave PageDate: 2002-11-26 20:21:09
Subject: Re: ODBC for Windows

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