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: F123sG06vdGg1fDc5DY00001187@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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(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 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


Responses

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-2014 The PostgreSQL Global Development Group