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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.

Browse pgsql-odbc by date

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