Reply-To: "angg" <angg@vng.ru>
From: "angg" <angg@vng.ru>
To: <pgsql-interfaces@hub.org>
Subject: [INTERFACES] C++ Builder (Delphi), ODBC and large objects
Date: Wed, 21 Oct 1998 09:23:27 +0500
Message-ID: <01bdfcaa$8d15d4e0$0b02a8c0@mis1>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: 7bit


David Hartwig (DH) wrote:
ANGG wrote:

ANGG>> 1 Does anybody use large objects with C++ Builder (Delphi), BDE,
ODBC,
ANGG>> PostgreSQL?

DH>Yes, occasionally - without any problem.

WHO?!!! Answer me, please (the problem makes me trow out half a year's work
as useless garbage).

DH>Have you seen
DH> http://www.insightdist.com/psqlodbc/psqlodbc_faq.html#largeobjects

Yes, I create large object as it reccomends
create type lo (
    internallength=4,  externallength=10,
    input=int4in, output=int4out,
    default='',  passedbyvalue
);
and have all the problems I say here about.

By the way, PostgreSQL's man create_type recommends another way to create
the large object type:
create type bigobj (
  input = lo_filein,
  output = lo_fileout,
  internallength = variable
);

But I have no Idea how should I implement lo_infile and lo_outfile. Can
anybody tell me how, or point to the information source.

Thank you, Mikhail.