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

Re: Support for DBD::PgSPI with Pg 7.4.8?

From: Scott Cain <cain(at)cshl(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Support for DBD::PgSPI with Pg 7.4.8?
Date: 2005-07-13 17:51:12
Message-ID: 1121277072.4169.14.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-interfaces
Tom,

Thanks! Of course I should have figured that out on my own.  Anyway, to
get it to work, I had to modify the Makefile.PL file for the
distribution.  It requires a $POSTGRES_HOME environment variable, which
doesn't help in Fedora, because files are spread all over the place.  I
just added a few items to the include list so that the appropriate
header files would be found.

Thanks,
Scott


On Wed, 2005-07-13 at 13:36 -0400, Tom Lane wrote:
> Scott Cain <cain(at)cshl(dot)edu> writes:
> > gcc -c  -I/var/lib/pgsql/include -I/var/lib/pgsql/backend -I/var/lib/pgsql/interfaces/libpq -I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -g   -DVERSION=\"0.02\" -DXS_VERSION=\"0.02\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE"   PgSPI.c
> > In file included from PgSPI.xs:14:
> > PgSPI.h:16:22: postgres.h: No such file or directory
> > PgSPI.h:17:21: funcapi.h: No such file or directory
> > PgSPI.h:18:26: executor/spi.h: No such file or directory
> > PgSPI.h:26:20: ppport.h: No such file or directory
> 
> Either you don't have those header files available, or the PgSPI
> makefile is confused about where to look for them --- the
> -I/var/lib/pgsql/include -I/var/lib/pgsql/backend switches look
> like rather generic guesses as to where they are...
> 
> All the other errors are probably just cascading from that.
> 
> 			regards, tom lane
-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain(at)cshl(dot)edu
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory


In response to

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2005-07-16 21:54:09
Subject: Re: ecpg and VARCHAR
Previous:From: Tom LaneDate: 2005-07-13 17:36:21
Subject: Re: Support for DBD::PgSPI with Pg 7.4.8?

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