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

Re: inserting blob data

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Bruce Holt" <bj_holt(at)hotmail(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: inserting blob data
Date: 2002-11-25 19:41:28
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128C67@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
> Sent: 25 November 2002 18:42
> To: Bruce Holt
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] inserting blob data 
> 
> 
> "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.

That version of the driver is recent - there has only been one update
since and most of those changes were to make it thread safe.

Regards, Dave.

pgsql-odbc by date

Next:From: Glen ParkerDate: 2002-11-25 21:15:34
Subject: Bug #2 in latest ODBC driver (07.02.0004)
Previous:From: Tom LaneDate: 2002-11-25 18:41:35
Subject: Re: inserting blob data

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