Обсуждение: pgsql_perl5-1.9.0 / Pg - patch for PQescapeString

Greetings all,

I just wanted to send you the attached patch which adds the
PQescapeString interface to the Pg module.

Earlier today, I forwarded this patch to Edmund Mergl
<e {dot} mergl {at} bawue {dot} de>, he suggested that
I should forward this patch to the appropriate list, as he no
longer maintains this module.  I assume he meant this list,
as I couldn't google another.

I also noticed that last discussions pertaining to this Perl
interfaces is years old. So, it may just be the case that it
might be a deprecated interface (hopefully I'm wrong).

Is there active maintenance of this module?


Two files that are touched are Pg.xs, which does the work, and
Pg.pm for the copy/paste documentation for PQescapeString()
function from PostgreSQL pdf doc.

I am not a XS expert, so I'd appreciate if you reviewed the patch
and if you find anything wrong you would let me know.

Hopefully you'll accept this change/patch :-)

Thanks,
--patrick

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I just wanted to send you the attached patch which adds the
> PQescapeString interface to the Pg module.

Unfortunately, you don't tell us exactly which module you mean.
There is the very actively maintained DBD::Pg module, and the
somewhat maintained DBD::PgPP module. There are also some
other older ones still floating around with a "Pg" in the name
- - the fact that you found Edmund Mergl's name suggests that
whatever you have, it is probably very old.

DBD::Pg can be found here:

http://search.cpan.org/~dbdpg/

It has its own quoting of variables through the $dbh->quote()
method. If you are trying to connect to Postgres via Perl,
this is probably your best bet. Hope that helps.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200604042024
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFEMw6HvJuQZxSWSsgRAs5aAJ426m5Tr3nXGqzvVHiMP6nu92RdZQCgyJxa
MFX4H56aRzoKrOCuxGb+DWk=
=ad2S
-----END PGP SIGNATURE-----

Hi Greg,


On 4/4/06, Greg Sabino Mullane <greg@turnstep.com> wrote:
> Unfortunately, you don't tell us exactly which module you mean.
> There is the very actively maintained DBD::Pg module, and the
> somewhat maintained DBD::PgPP module. There are also some
> other older ones still floating around with a "Pg" in the name
> - - the fact that you found Edmund Mergl's name suggests that
> whatever you have, it is probably very old.

My bad.  I should've included the link on CPAN (as you did):
   http://search.cpan.org/~mergl/pgsql_perl5-1.9.0/

And yes, it apparently is very old as it is dated '04 Apr 2000'.

The module just worked for my needs, so I started using it.
It only lacked access to PQescapeString or similar. Hence,
the patch.


> DBD::Pg can be found here:
>
> http://search.cpan.org/~dbdpg/
>
> It has its own quoting of variables through the $dbh->quote()
> method. If you are trying to connect to Postgres via Perl,
> this is probably your best bet. Hope that helps.

Might look at this module as my needs grow.

Thanks,
--patrick