Обсуждение: lo_import doesn't works through ODBC !

Поиск
Список
Период
Сортировка

lo_import doesn't works through ODBC !

От
fxcrazy@yahoo.com (Tom)
Дата:
Hi All,

  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
- Tom