Hi Greg thanks for writing: I know the server I am trying to connect to is not 7.4 or above. All I ever do with this old server is to run select queries. The error happens when I attempt to execute the select query. I updated my distribution of ubuntu and I had this set up to use an older version of DBD::Pg which according to my records may've been 1.49-5. I couldn't find that one from the CPAN site so I downloaded 1.32. I got this when I tried to do make: make cp Pg.pm blib/lib/DBD/Pg.pm /usr/bin/perl -p -e "s/~DRIVER~/Pg/g" /usr/lib/perl5/auto/DBI/Driver.xst > Pg.xsi /usr/bin/perl /usr/share/perl/5.14/ExtUtils/xsubpp -typemap /usr/share/perl/5.14/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c cc -c -I/usr/include/postgresql -I/usr/lib/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DHAVE_PQescapeString -DHAVE_PQescapeBytea -DHAVE_PQunescapeBytea -DHAVE_PQfreemem -O2 -g -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.32\" -DXS_VERSION=\"1.32\" -fPIC "-I/usr/lib/perl/5.14/CORE" Pg.c Pg.xs: In function ?XS_DBD__Pg__db_quote¹: Pg.xs:95:8: warning: format ?%i¹ expects argument of type ?int¹, but argument 2 has type ?IV¹ [-Wformat] Pg.xs: In function ?XS_DBD__Pg__db_lo_open¹: Pg.xs:166:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs:166:59: note: each undeclared identifier is reported only once for each function it appears in Pg.xs: In function ?XS_DBD__Pg__db_lo_close¹: Pg.xs:173:52: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:173:62: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_read¹: Pg.xs:194:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_write¹: Pg.xs:205:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_lseek¹: Pg.xs:216:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_creat¹: Pg.xs:225:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_tell¹: Pg.xs:234:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_unlink¹: Pg.xs:242:57: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:242:67: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_import¹: Pg.xs:251:53: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_export¹: Pg.xs:260:67: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:260:77: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_putline¹: Pg.xs:269:32: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:269:42: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_getline¹: Pg.xs:287:32: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:287:42: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_endcopy¹: Pg.xs:294:47: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:294:57: error: ?sv_no¹ undeclared (first use in this function) make: *** [Pg.o] Error 1 root@www:/home/lee/DBD-Pg-1.32# make >> makefile.txt Pg.xs: In function ?XS_DBD__Pg__db_quote¹: Pg.xs:95:8: warning: format ?%i¹ expects argument of type ?int¹, but argument 2 has type ?IV¹ [-Wformat] Pg.xs: In function ?XS_DBD__Pg__db_lo_open¹: Pg.xs:166:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs:166:59: note: each undeclared identifier is reported only once for each function it appears in Pg.xs: In function ?XS_DBD__Pg__db_lo_close¹: Pg.xs:173:52: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:173:62: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_read¹: Pg.xs:194:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_write¹: Pg.xs:205:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_lseek¹: Pg.xs:216:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_creat¹: Pg.xs:225:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_tell¹: Pg.xs:234:59: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_unlink¹: Pg.xs:242:57: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:242:67: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_import¹: Pg.xs:251:53: error: ?sv_undef¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_lo_export¹: Pg.xs:260:67: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:260:77: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_putline¹: Pg.xs:269:32: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:269:42: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_getline¹: Pg.xs:287:32: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:287:42: error: ?sv_no¹ undeclared (first use in this function) Pg.xs: In function ?XS_DBD__Pg__db_endcopy¹: Pg.xs:294:47: error: ?sv_yes¹ undeclared (first use in this function) Pg.xs:294:57: error: ?sv_no¹ undeclared (first use in this function) make: *** [Pg.o] Error 1 Does that mean I am missing a certain version of a library? Where could I get that at? Lee -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
