Large objects truncated when retrieved

From: Xavier Le Vourch <xavier(at)brittanysoftware(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Large objects truncated when retrieved
Date: 2003-10-03 18:47:33
Message-ID: 3F7DC445.5050806@brittanysoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm storing pictures in a table using the lo type definition from the
FAQ. The server version is 7.2.3 and the odbc driver is 7.3.100.

The images are stored correctly and can be retrieved on the server fine
using psql but the odbc driver truncates the objects at 32k+1 on the
retrieve (they were stored correctly though).

I've tried to increase the MaxLongVarChar setting in the datasource
definition or even set it to -4, according to the HOWTO describing the
configuration options but nothing works.

What is the correct way to increase the limit on large objects in the
odbc driver?

Thanks,
Xavier

--
Xavier Le Vourch
Brittany Software, Inc.
<xavier(at)brittanysoftware(dot)com>

PGP Key: http://brittanysoftware.com/gpg_key.asc

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-10-04 22:48:46 Re: Large objects truncated when retrieved
Previous Message markw 2003-10-03 12:23:08 Re: Convert database