Rishi Sharma <rsharma(at)Bigstep(dot)net> wrote:
> Let me try to clarify...the perl scripts try to load the Pg.pm module by
> stating "use Pg". You say this should be a binary file? I found a few
> copies of Pg.pm under .../perl/src or something like that, but it was ascii
> text, I didn't dig too deep in to what it was doing.
Ok, then it's clear your scripts are using the Pg driver bundled with PostgreSQL.
> I've found this http://www.edmund-mergl.de/export/DBD-Pg.zip from
> symbolstone (http://dbi.symbolstone.org/cgi/moduledump?module=DBD::Pg)...
> hopefully it's all I need.
From the point the above affirmation was made, any reference to DBI/DBD drivers becomes redundant. If your scripts use the Pg driver, migrating to DBI/DBD::Pg driver could be difficult, as they should be (quite some more than) batch changed.
> If I install postgresql-7.1.2 from Jason and drop in the libpq.dll and
> Pg.dll in my winnt/system32 should I be able to access my database from cgi
> scripts with simply stating "use Pg"??
> There seems to be something missing here...
Maybe yet another comment :) You must not forget to place Pg.pm somewhere so that Perl is able to find it. I think the layout with libpq.dll and pg.dll in winnt/system32 is viable. But, anyway, for any eventual problems, here's what "make install" in "src/interfaces/perl" produces:
$ ls -lR /usr/local/lib/perl5/site_perl/5.6.0/cygwin/
-r--r--r-- 1 lao 544 18124 Sep 27 1998 Pg.pm
drwxr-xr-x 3 lao 544 0 Jun 11 08:57 auto
drwxr-xr-x 2 lao 544 0 Jun 11 08:57 Pg
-r--r--r-- 1 lao 544 0 Jun 11 08:57 Pg.bs
-r-xr-xr-x 1 lao 544 73728 Jun 11 08:57 Pg.dll
-r--r--r-- 1 lao 544 81 Jun 11 08:57 autosplit.ix
-r--r--r-- 1 lao 544 93106 Jun 11 08:57 libPg.a
I think that a link to winnt/system32/Pg.dll in /usr/local/lib/perl5/site_perl/5.6.0/cygwin/auto/Pg could solve any (eventual) Perl instalation issues.
Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/
In response to
pgsql-cygwin by date
|Next:||From: Jason Tishler||Date: 2001-06-12 12:14:02|
|Subject: Re: tourble migrating from linux/Apache/postgresql/perl to win200 0/II S/postgresql/perl|
|Previous:||From: Robby Slaughter||Date: 2001-06-12 00:52:27|
|Subject: RE: Getting started on W2K installation of postgreSQL|