Re: Pg module for Perl [SUCCESS]

From: Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu>
To: <raanders(at)acm(dot)org>
Cc: <blindsey(at)cog(dot)ufl(dot)edu>, <alex(at)lintelsys(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pg module for Perl [SUCCESS]
Date: 2003-12-01 23:44:45
Message-ID: 1068.66.157.145.167.1070322285.squirrel@webmail.cog.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This was perfect. I also had to set the DBI_* envs. See test results
below. I then installed and successfully ran my own test.
Thanks to all who replied!
Barb

Test Results:
$ make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00basic...........ok
t/01connect.........ok 2/2#
# Package Version
# DBD::Pg 1.31
# DBI 1.38
# Postgres 7.4
t/01connect.........ok
t/01constants.......ok
t/01setup...........ok
t/02prepare.........ok
t/03bind............ok
t/04execute.........ok
t/04rows............ok
t/05fetch...........ok
t/06disconnect......ok
t/07reuse...........ok
t/08txn.............ok
t/09autocommit......ok
t/10chopblanks......ok
t/11quoting.........ok
t/12placeholders....ok
t/13pgtype..........ok
t/15column_info.....ok
t/15funct...........ok
t/15table_attrs.....ok
t/15table_info......ok
t/16pgbooltf........# DBD::Pg version: 1.31
t/16pgbooltf........ok
t/17arrays..........ok
t/99_pod............skipped
all skipped: Test::Pod 1.00 required for testing POD
t/99cleanup.........ok
All tests successful, 1 test skipped.
Files=25, Tests=268, 34 wallclock secs (10.72 cusr + 0.99 csys = 11.71 CPU)

:)

> On Mon, 1 Dec 2003, Barbara Lindsey wrote:
>
>> However, when I searched for DBD Pg on Google, it led me to a
>> DBD-Pg-1.22
>
> Try
>
> http://search.cpan.org/~rudy/DBD-Pg-1.31/Pg.pm
>
> Not sure if there are a lot of dependency issues going to Pg 7.4 as I'm
> in the process upgrading to 7.4 and all it's friends.
>
> One other issue that comes when installing DBI and/or DBD is the from
> the current (1.31) README file.
>
> ...
>
> INSTALLATION:
> -------------
>
> By default Makefile.PL uses App:Info to find the location of the
> PostgreSQL library and include directories. However, if you want to
> control it yourself, define the environment variables POSTGRES_INCLUDE
> and POSTGRES_LIB, or POSTGRES_HOME. Note that if you've compiled
> PostgreSQL with SSL support, you must define the POSTGRES_LIB
> environment varable and add "-lssl" to it, like this:
>
> export POSTGRES_LIB="/usr/local/pgsql/lib -lssl"
>
> ...
>
> Good luck to us both.
>
>
> Rod
> --
> "Open Source Software - Usually you get more than you pay for..."
> "Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rick Gigger 2003-12-01 23:58:24 Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL Advocacy, Thoughts and Comments
Previous Message Jay O'Connor 2003-12-01 23:42:54 Re: Good open source mailing list system PHP / Postgresql