Re: Quick perl question

Hi Ben,

Just a guess, but I suspect your installation went "slightly wrong".  When you
"make install" PostgreSQL, you do it as User "postgres".  It turns out that User
postgres does not have the required "root" permission to install Perl
extensions.  If you read thru your "make install log" carefully, you'll probably
see an error message to that effect just after the attempted install of Pg.pm.

I also would like to echo the comments that someone else has made about using
DBI::DBD rather than Pg.  Pg works well and is slightly easier to get working,
but that is because the complexity of DBI::DBD adds some useful stuff not
present in Pg. In particular, the error trapping is great. On the down side, it
gets tedious writting each query as two parts: "prepare" and "execute".  This is
compensated for in overall portability to other DBMS, I think.

You also need root permission to install DBI::DBD.

> I probably totally missed the docs on it, but I put PostgreSQL on
> my FreeBSD 3.4 box and I wanted to use some CGI scripts written
> in perl.  I installed Postgre 6.5.3 using the commands 'make
> USE_PERL=yes' and then 'make install'.  The installation is fine,
> but when I tried to make perl scripts using the Pg.pm library, I keep
> getting a "Can't locate Pg.pm in @INC..."
>
> I'm using perl5.  Did I do something in the installation incorrectly?
>
Mark Dalphin