How to deal with large object?

From: Pierre Couderc <pierre(at)couderc(dot)cc>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to deal with large object?
Date: 2005-05-19 18:42:51
Message-ID: 428CDE2B.8040107@couderc.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a how-to or a FAQ or deal with large objects?

I am using PostgreSQL 8.0.3 (on mingw32) and PSQLODBC.DLL 3.0

I have tried to use BYTEA but the driver gives me back :
type "lo" does not exist
wether I declare bytea as lo or not (in the ODBC driver)

I have tried too to declare :
create type lo (internallength=4, externallength=10, input=int4in,
output=int4out, default='', passedbyvalue);
but the ODBC driver answers (in log)
ERROR from backend during send_query: 'ERROR: function int4out(lo) does
not exist'
then crashes my program

I am a bit lost in docs...
Thank you in advance
Pierre Couderc

Browse pgsql-novice by date

  From Date Subject
Next Message Walker, Jed S 2005-05-19 19:29:58 Timezone into/out of function
Previous Message Van Ingen, Lane 2005-05-19 18:42:38 Trigger Function Problem