X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0F4925298A for ; Wed, 13 Jul 2005 14:20:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13766-03 for ; Wed, 13 Jul 2005 17:20:39 +0000 (GMT) Received: from mx-1.zoominternet.net (mx-1.zoominternet.net [24.154.1.20]) by svr1.postgresql.org (Postfix) with ESMTP id AAB80528BB for ; Wed, 13 Jul 2005 14:20:37 -0300 (ADT) Received: from mua-1.zoominternet.net (mua-1.zoominternet.net [24.154.1.44]) by mx-1.zoominternet.net (8.12.11/8.12.11) with ESMTP id j6DHKJ0A021274 for ; Wed, 13 Jul 2005 13:20:20 -0400 Received: from [192.168.0.188] (unknown [24.144.211.60]) by mua-1.zoominternet.net (Postfix) with ESMTP id 4D7EE7F414 for ; Wed, 13 Jul 2005 13:20:03 -0400 (EDT) Subject: Support for DBD::PgSPI with Pg 7.4.8? From: Scott Cain To: pgsql-interfaces@postgresql.org Content-Type: text/plain Date: Wed, 13 Jul 2005 13:19:38 -0400 Message-Id: <1121275178.4169.11.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-4) Content-Transfer-Encoding: 7bit X-CanItPRO-Stream: outgoing X-Scanned-By: CanIt (www . roaringpenguin . com) on 24.154.1.20 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/23 X-Sequence-Number: 5659 Hello, I am wondering if there is support for DBD::PgSPI in PostgreSQL 7.4.8 (that is, should I be able to build DBD::PgSPI with this Pg?). I tried to make it to no avail (make failed with several errors). This is on a Fedora Core 3 box with RPM installed postgres. Any suggestions would be appreciated! Thanks, Scott ------------ Here is the output of make: [root@localhost DBD-PgSPI-0.02]# export POSTGRES_HOME=/var/lib/pgsql [root@localhost DBD-PgSPI-0.02]# perl Makefile.PL Configuring PgSPI Remember to actually read the README file ! OS: linux Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 25 Using DBI 1.48 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ Checking if your kit is complete... Looks good Writing Makefile for DBD::PgSPI [root@localhost DBD-PgSPI-0.02]# make cp PgSPI.pm blib/lib/DBD/PgSPI.pm /usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.5/ExtUtils/typemap PgSPI.xs > PgSPI.xsc && mv PgSPI.xsc PgSPI.c 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 In file included from PgSPI.h:32, from PgSPI.xs:14: dbdimp.h:36: error: syntax error before "TupleDesc" dbdimp.h:36: warning: no semicolon at end of struct or union dbdimp.h:37: warning: data definition has no type or storage class dbdimp.h:47: error: syntax error before '*' token dbdimp.h:47: warning: data definition has no type or storage class dbdimp.h:52: error: syntax error before '}' token PgSPI.xs: In function `XS_DBD__PgSPI__st__prepare': PgSPI.xs:175: error: dereferencing pointer to incomplete type PgSPI.xs: In function `XS_DBD__PgSPI__st_execute': PgSPI.xs:233: error: dereferencing pointer to incomplete type PgSPI.xs:234: error: dereferencing pointer to incomplete type PgSPI.xs:235: error: dereferencing pointer to incomplete type PgSPI.xs: In function `XS_DBD__PgSPI__st_finish': PgSPI.xs:294: error: dereferencing pointer to incomplete type PgSPI.xs:301: error: dereferencing pointer to incomplete type PgSPI.xs: In function `XS_DBD__PgSPI__st_DESTROY': PgSPI.xs:345: error: dereferencing pointer to incomplete type PgSPI.xs:346: error: dereferencing pointer to incomplete type PgSPI.xs:351: error: dereferencing pointer to incomplete type PgSPI.xs:352: error: dereferencing pointer to incomplete type PgSPI.xs:352: error: dereferencing pointer to incomplete type PgSPI.xs:352: error: dereferencing pointer to incomplete type PgSPI.xs:354: error: dereferencing pointer to incomplete type PgSPI.xs: In function `boot_DBD__PgSPI': PgSPI.xs:36: error: invalid application of `sizeof' to incomplete type `/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/DBIXS.h' make: *** [PgSPI.o] Error 1 -- ------------------------------------------------------------------------ Scott Cain, Ph. D. cain@cshl.edu GMOD Coordinator (http://www.gmod.org/) 216-392-3087 Cold Spring Harbor Laboratory