Обсуждение: Large object support in ecpg
Hi, This is probably an FAQ but is there any direct support of large objects in ECPG? TIA. Bosco.
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.
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>
> 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
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.