Thread: Status of DBD:Pg and Pg interfaces for Perl

Status of DBD:Pg and Pg interfaces for Perl

From
"Jeff Duffy"
Date:
Greetings.
 The RC3 release has an ancient version of the perl Pg interface in
/src/interfaces/Perl5, which predates the DBI architecture, the
de-facto standard for interfacing with a database from Perl. The
upshot of this is that most people will install the DBD::Pg module
from CPAN rather than use the older Pg interface in the source tree,
and neither Pg.pm or DBD::Pg include the segfault-on-text-insert fix
Tom provided.
This means that as of now there is no obvious way to get a Perl5
driver that will work correctly with toasted fields in 7.1.  I have
emailed the maintainer (Edmund Mergl) twice in two weeks in an
attempt to get the patch applied, and he hasn't responded to either
of the emails, or any of the relevant threads on the DBI mailing
lists.
 What are the odds of getting DBD::Pg version 0.95 (the latest)
patched with Tom's fix, into the 7.1 release (maybe as an addition to
/src/interfaces/Perl5)? Can a new version of an interface library be
considered a bugfix if it does not work properly, as this one does
not? Or is it just too late in the cycle for his kind of addition (in
which case another method of access needs to be available)?

Jeff

-- Jeff Duffyjeff@alanne.com



Re: Status of DBD:Pg and Pg interfaces for Perl

From
The Hermit Hacker
Date:
too late in the cycle ...

On 8 Apr 2001, Jeff Duffy wrote:

> Greetings.
>
>   The RC3 release has an ancient version of the perl Pg interface in
> /src/interfaces/Perl5, which predates the DBI architecture, the
> de-facto standard for interfacing with a database from Perl. The
> upshot of this is that most people will install the DBD::Pg module
> from CPAN rather than use the older Pg interface in the source tree,
> and neither Pg.pm or DBD::Pg include the segfault-on-text-insert fix
> Tom provided.
>
>  This means that as of now there is no obvious way to get a Perl5
> driver that will work correctly with toasted fields in 7.1.  I have
> emailed the maintainer (Edmund Mergl) twice in two weeks in an
> attempt to get the patch applied, and he hasn't responded to either
> of the emails, or any of the relevant threads on the DBI mailing
> lists.
>
>   What are the odds of getting DBD::Pg version 0.95 (the latest)
> patched with Tom's fix, into the 7.1 release (maybe as an addition to
> /src/interfaces/Perl5)? Can a new version of an interface library be
> considered a bugfix if it does not work properly, as this one does
> not? Or is it just too late in the cycle for his kind of addition (in
> which case another method of access needs to be available)?
>
> Jeff
>
> --
>  Jeff Duffy
>  jeff@alanne.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org



windows installer for pgadmin..

From
lee johnson
Date:
okay i give up :) i can not find the microsoft windows installer that is linked at
greatbridge.org of the
three requirements to run pgadmin..its the only one i have left to get..when I get
to microsoft site i can't find it in the drop down list i'm presented
with...........what is it called? :)

thanks
lee






RE: windows installer for pgadmin..

From
"Francis Solomon"
Date:
Hi Lee,

Maybe this is what you're looking for:
http://www.microsoft.com/msdownload/platformsdk/instmsi.htm

Hope this helps

Francis

> 
> okay i give up :) i can not find the microsoft windows 
> installer that is linked at
> greatbridge.org of the
> three requirements to run pgadmin..its the only one i have 
> left to get..when I get
> to microsoft site i can't find it in the drop down list i'm presented
> with...........what is it called? :)
> 
> thanks
> lee
> 



Re: Status of DBD:Pg and Pg interfaces for Perl

From
Tom Lane
Date:
"Jeff Duffy" <jeff@alanne.com> writes:
> and neither Pg.pm or DBD::Pg include the segfault-on-text-insert fix
> Tom provided.

What?  Are you claiming that Pg.pm has a segfault problem in the same
area that DBD::Pg did?  The code is sufficiently different that that
would surprise me considerably.

>   What are the odds of getting DBD::Pg version 0.95 (the latest)
> patched with Tom's fix, into the 7.1 release (maybe as an addition to
> /src/interfaces/Perl5)?

Zip.  We do not ship DBD::Pg as part of the Postgres distribution, and
adding it now is not practical (makefile changes alone would create more
breakage risk than I care to consider).

If Edmund Mergl would like us to start shipping DBD::Pg in the
distribution, then I'd certainly consider that for 7.2 and later.
But right offhand, distributing it via CPAN seems to make more
sense, since you'd have to go to CPAN for DBI anyway...
        regards, tom lane