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..
Regards
- Sudhir
--
Disclaimer:
This document is intended for transmission to the named recipient only. If
you are not that person, you should note that legal rights reside in this
document and you are not authorized to access, read, disclose, copy, use or
otherwise deal with it and any such actions are prohibited and may be
unlawful. The views expressed in this document are not necessarily those of
HCL Technologies Ltd. Notice is hereby given that no representation,
contract or other binding obligation shall be created by this e-mail, which
must be interpreted accordingly. Any representations, contractual rights or
obligations shall be separately communicated in writing and signed in the
original by a duly authorized officer of the relevant company.