From: | "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "'Xavier Le Vourch'" <xavier(at)brittanysoftware(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Large objects truncated when retrieved |
Date: | 2003-10-04 23:38:52 |
Message-ID: | 016e01c38ad0$ab2c6570$3d283ddb@PbgX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Xavier Le Vourch
>
> Hiroshi Inoue wrote:
>
> >>-----Original Message-----
> >>From: Xavier Le Vourch
> >>Sent: Saturday, October 04, 2003 3:48 AM
> >>
> >>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).
> >
> >
> > Which data type are you using to store the images ?
>
> I'm using the lo type defined in the FAQ at:
>
> > And what kind of tools are you using ?
> > In most cases tools have their own limitations.
> I'm using Borland C++ 6 but the problem seems to be coming from the
> driver as when I enabled logging, I get messages like:
> conn=67191248, query='COMMIT'
> The 2th item was truncated
> The buffer size = 32769 and the value is '1040924'
Could you send me the Mylog debug output ?
regards,
Hiroshi Inoue
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | HIDING | 2003-10-05 13:59:14 | odbc eating parser error messages? |
Previous Message | Xavier Le Vourch | 2003-10-04 23:14:07 | Re: Large objects truncated when retrieved |