lo_import doesn't works through ODBC !

From: fxcrazy(at)yahoo(dot)com (Tom)
To: pgsql-general(at)postgresql(dot)org
Subject: lo_import doesn't works through ODBC !
Date: 2003-04-13 00:07:27
Message-ID: 633e72d2.0304121607.61ed7fef@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2003-04-13 01:00:20 Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit
Previous Message Bruno Wolff III 2003-04-12 22:47:01 Re: Case sensitive order by