Message-ID: <4C75AEF8.80605@boscorama.com>
Date: Wed, 25 Aug 2010 17:02:00 -0700
From: Bosco Rama <postgres@boscorama.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
	rv:1.9.1.11) Gecko/20100701 SeaMonkey/2.0.6
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: Large object support in ecpg
References: <4C5B3878.4000101@boscorama.com>
In-Reply-To: <4C5B3878.4000101@boscorama.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi again,

Bosco Rama wrote:
> 
> This is probably an FAQ but is there any direct support of large
> objects in ECPG?

So from the lack of response I assume not.  I certainly couldn't find
any reference to large objects in the ecpg docs, web or any forums.

The issue I have is that I want to integrate a large object into a
transaction started in a function using ecpg.  This means I have to
use ecpg to perform the large object 'write' (I'd prefer a stream
methodology) or 'import'.  Either that or I need to grab a reference
to the connection used by the ecpg lib and use it in some PQ code.
I'm not sure I can do either of those as it stands now.

I guess I could also try ecpg against a transaction started in PQ code
but that seems even more fraught with danger.  And is even less obvious.

BTW, we are using 8.4.4 right now.

Any words of wisdom from the ecpg cognoscenti?

Thanks for any help with this.

Bosco.