From: Mark Dalphin <mdalphin@amgen.com>
To: pgsql-interfaces@postgresql.org
Cc: bweaver@tranquility.net
Subject: Re: Quick perl question
Date: Mon, 06 Mar 2000 09:56:01 -0800
Message-ID: <38C3F131.215DB6A5@amgen.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mdalphin@amgen.com, bweaver@tranquility.net
Subject: Re: Quick perl question
In-Reply-To: <38C3F131.215DB6A5@amgen.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox