Large object support in ecpg

agora inbox for pgsql-interfaces@postgresql.org  
help / color / mirror / Atom feed

Large object support in ecpg
5+ messages / 3 participants
[nested] [flat]

* Large object support in ecpg
@ 2010-08-05 22:17  Bosco Rama <postgres@boscorama.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Bosco Rama @ 2010-08-05 22:17 UTC (permalink / raw)
  To: pgsql-interfaces

Hi,

This is probably an FAQ but is there any direct support of large
objects in ECPG?

TIA.

Bosco.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Large object support in ecpg
@ 2010-08-26 00:02  Bosco Rama <postgres@boscorama.com>
  parent: Bosco Rama <postgres@boscorama.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Bosco Rama @ 2010-08-26 00:02 UTC (permalink / raw)
  To: pgsql-interfaces

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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Large object support in ecpg
@ 2010-08-26 03:57  Michael Meskes <meskes@postgresql.org>
  parent: Bosco Rama <postgres@boscorama.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Michael Meskes @ 2010-08-26 03:57 UTC (permalink / raw)
  To: Bosco Rama <postgres@boscorama.com>; +Cc: pgsql-interfaces

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

Sorry, I'm travelling and have to do quite some cath up afterwards.

Michael
-- 
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes@jabber.org
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Large object support in ecpg
@ 2010-08-26 12:25  Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
  parent: Bosco Rama <postgres@boscorama.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Satoshi Nagayasu @ 2010-08-26 12:25 UTC (permalink / raw)
  To: Bosco Rama <postgres@boscorama.com>; +Cc: pgsql-interfaces

Hi Bosco,

On 2010/08/26 9:02, Bosco Rama wrote:
> 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.

I had some experiences on using large objects in ECPG
with using ECPGget_PGconn(). However, ECPGget_PGconn() is
not recommended in ECPG application, so it's "at your own risk".

For more details, please download my document from below,
and check "Large Objects" section to handle large objects.

http://code.google.com/p/ecpgdocs/downloads/detail?name=ecpg_html.zip&can=2&q=#makechanges

Thanks,
-- 
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Large object support in ecpg
@ 2010-08-26 17:28  Bosco Rama <postgres@boscorama.com>
  parent: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Bosco Rama @ 2010-08-26 17:28 UTC (permalink / raw)
  To: pgsql-interfaces

Satoshi Nagayasu wrote:
> 
> I had some experiences on using large objects in ECPG
> with using ECPGget_PGconn(). However, ECPGget_PGconn() is
> not recommended in ECPG application, so it's "at your own risk".
> 
> For more details, please download my document from below,
> and check "Large Objects" section to handle large objects.
> 
> http://code.google.com/p/ecpgdocs/downloads/detail?name=ecpg_html.zip&can=2&q=#makechanges

Thanks for this.  I wonder why a google search didn't find this?
Anyway, that describes pretty much what I figured I'd have to do.

However, I would really like a sanctioned method.  It seems that
using the above function is not deemed 'proper'.  But if this is
the only way to do it, then I guess I'll need to be a bad boy. :-)

Thanks again.

Bosco.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

end of thread, other threads:[~2010-08-26 17:28 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-05 22:17 Large object support in ecpg Bosco Rama <postgres@boscorama.com>
2010-08-26 00:02 ` Bosco Rama <postgres@boscorama.com>
2010-08-26 03:57   ` Michael Meskes <meskes@postgresql.org>
2010-08-26 12:25   ` Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
2010-08-26 17:28     ` Bosco Rama <postgres@boscorama.com>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox