Re: Postgres and Perl: Which DBI module?

On Fri, 2002-08-02 at 18:45, phildobbin@pobox.com wrote:
> I was only questioning the syntax of setting the environment variable
> generally that the book sets out (pp.25).

Those are very different env variables that are not at all related to
DBD::Pg which does not come with the PostgreSQL distribution.

> I _think_ Pg and DBD::Pg are the same thing, just different ways of
> saying things (i.e. Pg module would be DBD::Pg).

Nope. That's what I was saying. Pg is NOT DBD::Pg. The module that comes
bundled with Postgres is Pg, a very low level wrapper.

> I called it from CPAN after all ;-)

http://search.cpan.org/doc/MERGL/pgsql_perl5-1.9.0/Pg.pm -- CPAN Pg
http://search.cpan.org/doc/JBAKER/DBD-Pg-1.13/dbd-pg.pod -- CPAN DBD::Pg

Very different modules.

(Edmund Mergl originally wrote both, Jeffery Baker recently took over
maintaining DBD::Pg)

> In order to use DBI/DBD with postgres, it's the only way
> to do it as far as I can see (``There's more than one way to do it" anon ;-)
>
> O'Reilly's ``PostgreSQL" and ``Programming the Perl DBI" are both pretty
> vague on this (I have both). I'll also post to dbi-perl and see what
> gives (or what Tim Bunce sez...).

I fully agree. The PostgreSQL book only talks about the bundled module
(Pg) and PL/Perl and both only to mention they exist. 'Programming the
Perl DBI' just includes DBD::Pg's POD in the appendix, the installation
instructions are actually in the README in the archive.

Maybe it's time to add an interactive bit to the modules install (with a
flag to deactivate it). This question crops up often and it makes CPAN
installs hard for many people.