Re: Perl DBI - Mailing list pgsql-novice

More specifically, if you type the following at the command line:

perl -MCPAN -e 'install Pg::Simple'

What happens?

Doug Gorley | douggorley@shaw.ca


----- Original Message -----
From: Cheryl Thompson <cthompso@ci.irving.tx.us>
Date: Tuesday, January 21, 2003 11:31 am
Subject: Re: [NOVICE] Perl DBI

> This is the module Pg::Simple found at
> http://www.cpan.org/modules/by-category/07_Database_Interfaces/Pg/
> which is
> linked as /PG/ but actually named PG Simple.
>
>
> -----Original Message-----
> From: douggorley@shaw.ca [mailto:douggorley@shaw.ca]
> Sent: Tuesday, January 21, 2003 1:26 PM
> To: Cheryl Thompson
> Cc: 'pgsql-novice@postgresql.org'
> Subject: Re: [NOVICE] Perl DBI
>
>
> Just a thought, but have you tried installing Pg::Simple via CPAN
> as well?
>
> Doug Gorley | douggorley@shaw.ca
>
>
> ----- Original Message -----
> From: Cheryl Thompson <cthompso@ci.irving.tx.us>
> Date: Tuesday, January 21, 2003 11:18 am
> Subject: [NOVICE] Perl DBI
>
> > I'm sorry if this is the wrong forum... if someone knows of a
> > better forum
> >
> (alt.users.trying.to.run.postgres.and.perl.with.apache.on.windows
> > doesn'texist :D), please let me know.
> >
> > Thanks to the many helpful people in this group I located the
> > DBD::Pg files
> > on CPAN.
> > However, following the instructions for PgSimple (this is all
> > being done on
> > the Cygwin side), I get an error that has stumped the one person
> > in the
> > office who uses Perl. (He came up with the supremely helpful:
> "You're> missing the Perl module for postgresql." To which my
> reply is,
> > "This IS the
> > Perl module for PostGresQL").
> >
> > Has anyone set up this configuration? Can you tell me what I'm
> > doing wrong
> > here??? (Besides trying to ignore the first error in hopes it
> > would go
> > through steps 2 and 3 anyway).
> >
> > I can read this and say, "Ok, it can't find Perl", but I don't
> > know how to
> > tell it "hey, Perl is over here---> /Perl".
> >
> > I have currently on this box:
> > Apache 2.0.3
> > Cygwin
> > Postgresql (runs through Cygwin)
> > Active Perl 5.8
> >
> > [Should I have installed a different Perl through Cygwin as a
> > LINUX build,
> > not through windows as Active Perl?? Would Apache and everything
> > ELSE then
> > have to run through Cygwin? I can see that being an issue; on
> the
> > other hand
> > it seems kind of a silly way to do this. Access through Windows
> > can see
> > Postgresql; why can't Perl?]
> >
> > Thanks,
> > Cheryl "I Hope To Stop Posting To This List Real Soon Now" Thompson
> >
> > ---------------------Cut N
> > Paste---------------------------------------------
> >
> > cthompso@MyBox /Pg-Simple-1.0
> > $ ls
> > COPYRIGHT  LICENSE   Makefile     README     test.pl
> > Changes    MANIFEST  Makefile.PL  Simple.pm
> >
> > cthompso@MyBox /Pg-Simple-1.0
> > $ perl Makefile.pl
> > Warning: prerequisite Pg failed to load: Can't locate Pg.pm in
> > @INC (@INC
> > conta
> > ns: /usr/lib/perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1
> > /usr/lib/perl5/site_
> > erl/5.6.1/cygwin-multi /usr/lib/perl5/site_perl/5.6.1
> > /usr/lib/perl5/site_perl
> > ) at (eval 4) line 3.
> > Writing Makefile for Pg::Simple
> >
> > cthompso@MyBox /Pg-Simple-1.0
> > $ make
> > cp Simple.pm blib/lib/Pg/Simple.pm
> > Manifying blib/man3/Pg.Simple.3
> >
> > cthompso@MyBox /Pg-Simple-1.0
> > $ make test
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/lib/perl5/5.6.1/c
> > gwin-multi -I/usr/lib/perl5/5.6.1 test.pl
> > 1..1
> > Can't locate Pg.pm in @INC (@INC contains: blib/arch blib/lib
> > /usr/lib/perl5/5.
> > .1/cygwin-multi /usr/lib/perl5/5.6.1/cygwin-multi
> /usr/lib/perl5/5.6.1> /usr/lib
> > perl5/5.6.1/cygwin-multi /usr/lib/perl5/5.6.1
> > /usr/lib/perl5/site_perl/5.6.1/cy
> > win-multi /usr/lib/perl5/site_perl/5.6.1
> /usr/lib/perl5/site_perl
> > .) at
> > blib/li
> > /Pg/Simple.pm line 67.
> > BEGIN failed--compilation aborted at blib/lib/Pg/Simple.pm line 67.
> > Compilation failed in require at test.pl line 10.
> > BEGIN failed--compilation aborted at test.pl line 10.
> > make: *** [test_dynamic] Error 2
> >
> > cthompso@MyBox /Pg-Simple-1.0
> >
> >
> > ---------------------------(end of broadcast)--------------------
> --
> > -----
> > TIP 1: subscribe and unsubscribe commands go to
> > majordomo@postgresql.org
>
>
> ---------------------------(end of broadcast)----------------------
> -----
> TIP 4: Don't 'kill -9' the postmaster
>