Thread: RE: [GENERAL] perl dbi:pg

Thanks for your help.
I think I got the right perl package now, however I still have a problem
compiling the DBD:pg

make
cc -c -I/install/postgresql/postgresql-snapshot/src/interfaces/libpq -I/usr/
local/lib/perl5/site_perl/5.6.0/i686-linux/auto/DBI -fno-strict-aliasing -I/
usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2     -DVERSI
ON=\"0.96\" -DXS_VERSION=\"0.96\" -fpic -I/usr/local/lib/perl5/5.6.0/i686-li
nux/CORE  Pg.c
In file included from Pg.h:17,
                 from Pg.xs:13:
/install/postgresql/postgresql-snapshot/src/interfaces/libpq/libpq-fe.h:27:
postgres_ext.h: No such file or directory
make: *** [Pg.o] Error 1

DBD-Pg-0.96

This is the enviroment var:
POSTGRES_INCLUDE=/install/postgresql/postgresql-snapshot/src/interfaces/libp
q


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Brett W. McCoy
> Sent: Tuesday, April 10, 2001 9:11 AM
> To: Joseph
> Cc: Pgsql-General
> Subject: Re: [GENERAL] perl dbi:pg
>
>
> On Tue, 10 Apr 2001, Joseph wrote:
>
> > I got the pgsql_perl5-1.9.0.tar.gz from CPAN.
> > I set the variables POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
> > and POSTGRES_INCLUDE=/path_to_/libpq-fe.h
> > However then it complains that it can't find postgres_ext.h
>
> POSTGRES_LIB and POSTGRES_INCLUDE must point to directories, not files.
>
> Keep in mind that this is NOT DBD::Pg -- you are using the native Perl
> interface.  DBD::Pg is a different module on CPAN.
>
> -- Brett
>                    http://www.chapelperilous.net/btfwk/
> ------------------------------------------------------------------------
> Writing about music is like dancing about architecture.
>         -- Frank Zappa
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

On Tue, 10 Apr 2001, Joseph wrote:

> DBD-Pg-0.96
>
> This is the enviroment var:
> POSTGRES_INCLUDE=/install/postgresql/postgresql-snapshot/src/interfaces/libp
> q

This is still incorrect.  Typically, POSTGRES_INCLUDE will point to
/usr/local/pgsql/include, and POSTGRES_LIB will point to
/usr/local/pgsql/lib, assuming you have PostgreSQL installed under
/usr/local/pgsql.  If you installed via RPM, your PostgreSQL includes and
libraries may be under /usr/include and /usr/lib, respectively.

-- Brett
                   http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
You will find me drinking gin
In the lowest kind of inn,
Because I am a rigid Vegetarian.
        -- G.K. Chesterton