Re: DBD::Pg on UnixWare

Thomas Good wrote:
> 
> Vital Signs:
> ------------
> Database version:     PostgreSQL 6.3.2
> Alleged OS:           UnixWare 2.1.2
> Perl Version:         Perl 5.004_04
> DBI Module:           DBI 0.91
> DBD Driver:           DBD-Pg 0.69
> 
> Gratuitous Whining:
> ------------------
> This combination runs fine on Linux 2.0.30 (Slackware 3.4) and
> FreeBSD 2.2.7 and 2.2.8 (Perl 5.005) but, like so many other things,
> has trouble working properly on UnixWare...
> 
> Symptoms:
> ---------
> The most rudimentary report that uses DBI::DBD-Pg to return a cursor
> select is failing with:
> 
> dynamic linker: /usr/bin/perl: symbol not found: strncasecmp
> 
> Debug Attempt:
> -------------
> perl debug shows that the query is dying at line 101 of Pg.pm:
> 
> 101:  DBD::Pg::db::prepare(/opt/lib/perl5/site_perl/DBD/Pg.pm: 101):
>       DBD::Pg::st_prepare($sth, $statement, @attribs)
> 102:          or return undef;
> 
> If I comment out the PAGER simply connect to the db I can do so
> without complaint.  My $dbh->disconnect also exits without err.
> 
> Any advice most appreciated (danke sehr, Edmund)...
> Tom
> ----
>          North Richmond Community Mental Health Center
> 
>          Thomas Good   Information Systems Coordinator
>          E-Mail:       tomg@ { admin | q8 } .nrnet.org
>          Phone:        718-354-5528
>          Fax:          718-354-5056
> 
>                  Empowered by PostgreSQL 6.3.2


in Pg.xs replace strncasecmp() by strncmp(). 
The check, in which strncasecmp is used,
will not be as strict, as it should, but 
this is not critical.

Edmund

-- 
Edmund Mergl          mailto:E.Mergl@bawue.de
Im Haldenhau 9        http://www.bawue.de/~mergl
70565 Stuttgart       fon: +49 711 747503
Germany