Skip site navigation (1) Skip section navigation (2)

Problem installing Pg.pm on FreeBSD

From: Aaron Cutchin <aaroncutchin(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Problem installing Pg.pm on FreeBSD
Date: 2002-10-30 01:35:16
Message-ID: 20021030013516.6782.qmail@web14908.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
I am having a problem installing Pg.pm on a new
installation of FreeBSD 4.6.  I have installed the
following ports:

p5-DBD-Pg-1.13
p5-Pg-7.2.3
p5-postgresql-plperl-7.2.3
postgresql-7.2.3
p5-DBI-1.28

I am using a test script from
http://home.school.net.hk/~hywong/postgres.html.  The
script is included below.

I get the following error message when I try to run
the script:

Can't locate auto/Pg/new.al in @INC (@INC contains:
/usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.00503
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005 .) at ./test.pl
line 15

I have a directory
"/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/Pg",
but there is no file named "new.al" in it!

Was this file supposed to have been installed?

Thanks a lot for the help!  Details below:


--  Aaron
--  aaron(dot)DELETE(dot)cutchin(at)THESE(dot)yahoo(dot)WORDS(dot)com


------------------------------------------------------

Output of perl -v:
------------------
This is perl, version 5.005_03 built for i386-freebsd
Copyright 1987-1999, Larry Wall
...


Output of perl -V
-----------------
Summary of my perl5 (5.0 patchlevel 5 subversion 3)
configuration:
  Platform:
    osname=freebsd, osvers=4.0-current,
archname=i386-freebsd
    uname='FreeBSD freefall.FreeBSD.org 4.0-current
FreeBSD 4.0-current #0: $Date$'
    hint=recommended, useposix=true,
d_sigaction=define
    usethreads=undef useperlio=undef d_sfio=undef
  Compiler:
    cc='cc', optimize='undef', gccversion=2.95.2
19991024 (release)
    cppflags=''
    ccflags =''
    stdchar='char', d_stdstdio=undef, usevfork=true
    intsize=4, longsize=4, ptrsize=4, doublesize=8
    d_longlong=define, longlongsize=8,
d_longdbl=define, longdblsize=12
    alignbytes=4, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='cc', ldflags ='-Wl,-E -lperl -lm '
    libpth=/usr/lib
    libs=-lm -lc -lcrypt
    libc=, so=so, useshrplib=true,
libperl=libperl.so.3
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef,
ccdlflags=' -Wl,-R/usr/lib'
    cccdlflags='-DPIC -fpic', lddlflags='-Wl,-E
-shared -lperl -lm '

Characteristics of this binary (from libperl):
  Built under freebsd
  Compiled at Jun 11 2002 03:54:48
  @INC:
    /usr/libdata/perl/5.00503/mach
    /usr/libdata/perl/5.00503
    /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
    /usr/local/lib/perl5/site_perl/5.005


Version of PostGreSQL:
----------------------
I am assuming 7.2.3, because that is the name of the
FreeBSD Port I installed.


Version of "pgsql-perl5":
-------------------------
I don't know what this is.  Is this a FreeBSD Port?  I
do not see it in the tree.  If this is the missing
link, shouldn't it be installed from the Ports tree?


Test Script:
------------
#!/usr/bin/perl
use Pg;
use CGI qw(:standard);

print header;
print start_html('A PostgresSQL Example'),
      h1('A PostgresSQL Example'),
      start_form,
      "SQL: select * from test",
      p,
      submit,
      end_form,
      hr;

$conn = Pg::new('','','','','hywong');

$sql = "select * from test";

$result = $conn->exec($sql);

$t = '1';
$html3 = $t;
$align = $t;
$header = $t;
$tableOpt = 'Border';

$result->print(stdout, $header, $align, $standard,
$html3, $expanded,
               $pager, $fieldSep, $tableOpt,
$caption);

print end_html;

exit;

__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/

pgsql-interfaces by date

Next:From: Evert CartonDate: 2002-10-30 04:45:50
Subject: API Question v7.3
Previous:From: prashanthDate: 2002-10-29 20:12:16
Subject: Re: Non-blocking libpq in 7.3 beta2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group