Psql ODBC and 'lo' type in PostgreSQL 6.4.x (error inserting large obj...)

From: Wojciech Kromer <krom(at)softomat(dot)com(dot)pl>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Psql ODBC and 'lo' type in PostgreSQL 6.4.x (error inserting large obj...)
Date: 1999-03-29 16:02:56
Message-ID: 36FFA430.CB7DAF36@softomat.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I found where the problem is.

In the file "convert.c" from PsqlODBC dll source code i found the
line:
...
sprintf(param_string, "%d", lobj_oid);
...
for PostrgeSQL 6.3 it's OK, but for 6.4 shoul be
...
sprintf(param_string, "%d::lo", lobj_oid);
...
or something like this.
My sugestion to autors of PsqlODBC is to add an option to the ODBC
driver.

Could anyone compile PsqlODBC and test it?
I don't have any Microsoft Copmiler Stuff...,
... or anyone wrote a makefile for mingw

If You have soullution please send me one

PS. I don't like to go back to 6.3.....

--
%%
Kazda cywilizacja musi dojsc do momentu, w ktorym wymysli PIWO!
%%
Wojciech Kromer mailto:krom(at)softomat(dot)com(dot)pl

Browse pgsql-interfaces by date

  From Date Subject
Next Message Wojciech Kromer 1999-03-29 16:19:01 [INTERFACES] type error inserting large obj, Win32 ODBC
Previous Message Thomas Lockhart 1999-03-29 16:00:43 Re: (fwd) problems with Java