Bug #53835 for DBD-Pg: Add lo_create() and lo_import_with_oid() to DBD::Pg to create large objects

Wed Jan 20 01:27:15 2010 doj [...] cubic.org - Ticket created

Subject:

Add lo_create() and lo_import_with_oid() to DBD::Pg to create large objects

PostgreSQL 8.4 contains two new functions to create/import large objects while explicitely setting their oid: lo_create() and lo_import_with_oid(). It would be great if a future version of DBD::Pg gives access to these functions. Details on those functions are found in the PostgreSQL manual: http://www.postgresql.org/docs/8.4/interactive/lo-interfaces.html

Wed Jan 20 16:16:46 2010 greg [...] turnstep.com - Correspondence added

lo_create is not new to 8.4 (but we should support it someday). I've added support for lo_import_with_oid in r13758 if you want to take a look.

Wed Jan 20 16:16:54 2010 The RT System itself - Status changed from 'new' to 'open'

Thu Jan 21 01:26:43 2010 doj [...] cubic.org - Correspondence added

Subject:	Re: [rt.cpan.org #53835] Add lo_create() and lo_import_with_oid() to DBD::Pg to create large objects
Date:	Wed, 20 Jan 2010 22:24:43 -0800
To:	bug-DBD-Pg [...] rt.cpan.org
From:	Dirk Jagdmann <doj [...] cubic.org>

Hello Greg, Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=53835 > > > lo_create is not new to 8.4 (but we should support it someday). I've > added support for lo_import_with_oid in r13758 if you want to take a look.

Thank you for working on this so fast. I've taken a look at the Pg.xs code and it looks fine. I will have to convert my current code from the old $dbh->func('lo_*') to the new large object functions and while doing that I can test the new lo_import_with_oid. -- ---> Dirk Jagdmann ----> http://cubic.org/~doj -----> http://llg.cubic.org

Thu Jan 21 01:32:33 2010 doj [...] cubic.org - Correspondence added

Subject:	Re: [rt.cpan.org #53835] Add lo_create() and lo_import_with_oid() to DBD::Pg to create large objects
Date:	Wed, 20 Jan 2010 22:30:47 -0800
To:	bug-DBD-Pg [...] rt.cpan.org
From:	Dirk Jagdmann <doj [...] cubic.org>

I've noticed some outdated documentation. See the attachted patch. -- ---> Dirk Jagdmann ----> http://cubic.org/~doj -----> http://llg.cubic.org

Index: Pg.pm =================================================================== --- Pg.pm (revision 13758) +++ Pg.pm (working copy) @@ -4119,7 +4119,7 @@ =head2 Large Objects DBD::Pg supports all largeobject functions provided by libpq via the -C<func> method. Please note that access to a large object, even read-only +C<$dbh->pg_lo_*> methods. Please note that access to a large object, even read-only large objects, must be put into a transaction. =head2 Cursors

Fri Jan 22 10:14:07 2010 greg [...] turnstep.com - Correspondence added

Subject:	Re: [rt.cpan.org #53835] Add lo_create() and lo_import_with_oid() to DBD::Pg to create large objects
Date:	Fri, 22 Jan 2010 15:13:41 -0000
To:	bug-DBD-Pg [...] rt.cpan.org
From:	"Greg Sabino Mullane" <greg [...] turnstep.com>

-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Show quoted text

> I've noticed some outdated documentation. See the attached patch.

Applied, thanks! - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201001221013 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAktZwJMACgkQvJuQZxSWSsgKpwCfdRuew68lq1Qizsqi5l8DfSdC TKYAoPk3Fp/wK0TT9epeaUDvrPjVIpXL =25hi -----END PGP SIGNATURE-----

Fri Jan 22 10:14:18 2010 greg [...] turnstep.com - Status changed from 'open' to 'patched'

Wed Dec 01 20:38:46 2010 greg [...] turnstep.com - Fixed in 2.17.0 added

Wed Dec 01 20:38:46 2010 greg [...] turnstep.com - Status changed from 'patched' to 'resolved'