Re: lo_import doesn't works through ODBC !

I am running
    PostgreSQL => 7.2.1 on RedHat 7.3
    unixODBC   => 2.2.4
    And I beleive the psqlodbc driver that 'm using is part of the
      default drivers included by unixODBC...

   Should i download and compile a newer version of unixODBC or
   the psqlodbc driver from the postgresql.org ?

   I am stuck coz of this ! Otherwise is it possible to store binary
   data straight in to the database without lo_import/lo_export ?
   I couldn't find any proper literature yet to achieve this. Seems
   bytea does this and i should filter some escape sequences to
   achieve binary data storage.....

   It wld be great if i can get some help here !

Regards
- Sudhir

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
Sent: Monday, April 14, 2003 8:27 AM
To: Sudhir S, Noida
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] lo_import doesn't works through ODBC !


"Sudhir S, Noida" wrote:
>
>   I am successful by trying the following SQL statement in the psql
prompt.
>   INSERT INTO image (name, raster)
>   VALUES ('myimg', lo_import('/var/lib/pgsql/CmpJpg.jpg'));
>
>   Through the psql interface this works properly and i have tried the
>   same using the UnixODBC's isql interface as well which again works
>   perfectly.
>
>   The problem is, the same SQL statement doesn't works through ODBC, I
have
>   no clues why it doesn't ?  And when i tried to debug the application
>   at some point of time i can notice that "Error while executing the Query
>   (non-fatal)" and the return value is STMT_INFO_ONLY
>
>   Any inputs on this problem would be hightly appreciated..

You seem to be using a pretty old driver.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/