[plug] pgsql_perl5 compile problem

[Denis Brown]

Dear PLUG members,

I have perl 5.004_04 and postgreSQL 7.0.3 on a Debian (GNU/Linux 2.1 with 
security patches applied as they come to hand) box, with the ultimate aim 
of using Apache's mod_perl to access pgsql databases.  Both perl and 
postgres appear to have compiled okay so now I would like to add 
pgsql_perl5 (version 1.9.0) so that I can access the database functionality 
through perl.  The environment variables POSTGRES_LIB and POSTGRES_INCLUDE 
are correctly set.  The "perl Makefile.PL" command goes okay (no 
errors).  However a subsequent "make" operation returns, along with the 
usual informational lines...

Pg.xs: In function `XS_PG_conn_lo_read':
Pg.xs:435: `PL_sv_undef' undeclared (first use this function)
Pg.xs:435: (Each undeclared identifier is reported only once
Pg.xs:435: for each function it appears in.)
Pg.xs: In function `XS_PG_results_fetchrow':
Pg.xs:666: `PL_sv_undef' undeclared (first use this function)
make: *** [Pg.o] Error 1

I am running this as user "postgres" which implicitly has rights for 
database creation.  In fact it is the postmaster account for 
PostgreSQL.  As noted, environment variables are set and these can be seen, 
correctly, in some of the informational lines ahead of the error 
block.  Path information appears to have been correctly specified in the 
resulting Makefile and, yes, the paths do exist.

A hunt on the net shows mail from the pgsql_interfaces list in June 1999 
where another potential user ran into very similar problems.  Unfortunately 
the thread dried up without any apparent resolution and attempts to contact 
the correspondents indicate their accounts are no longer active.  There are 
a daunting number of files to look through in the include directory (the 
header files) for anything to do with PL_sv... and looking initially in 
sv.h failed to show anything like it.

So, has anyone here successfully compiled pgsql_perl5 or, could you suggest 
a reasonable next approach other than joining the pgsql_inerfaces list?

Regards,
Denis