Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UlWPY-0006tm-5E for pgsql-admin@arkaria.postgresql.org; Sun, 09 Jun 2013 03:35:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UlWPX-00082s-FK for pgsql-admin@arkaria.postgresql.org; Sun, 09 Jun 2013 03:35:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UlWPW-00082m-CX for pgsql-admin@postgresql.org; Sun, 09 Jun 2013 03:35:18 +0000 Received: from mail-oa0-x233.google.com ([2607:f8b0:4003:c02::233]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UlWPR-0001xD-SO for pgsql-admin@postgresql.org; Sun, 09 Jun 2013 03:35:17 +0000 Received: by mail-oa0-f51.google.com with SMTP id i4so525945oah.38 for ; Sat, 08 Jun 2013 20:35:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=user-agent:date:subject:from:to:cc:message-id:thread-topic :in-reply-to:mime-version:content-type:content-transfer-encoding; bh=hqYplzJc3yQJaXbq8m/oGvpFFjH/fFocPYEnATx7hzs=; b=uykT36vCWK8L77q/7C4f9a3qWkKaxQenbVC5cev5rpBUsLLt845h5eYYIFQ3rgdDZS zsdvwhmf0sZx4B6B2x8m34QGphTw4NRVMv/oQU4+rBP4i5kRf35iRTRjk4hPQyJR4QjB isr7ak8P4sE/wjZB8NKRqHm2R0kRoh166VW2ad5xULZ118ikTYPSUbxRCDt+d/NcEN1f A916+nnf/lNQBGqP1MCrFP5P+xraifT6o0y9F3nD0w5oO2PqPmuBk01ONjFS7qEPvlNw VtIFpC5KGp9YJdjb113fGN9ZOmOztpxjM1X4gEFof5XeMfU8iAy2HMUwkuWN5HatyUYs 4rXw== X-Received: by 10.60.50.202 with SMTP id e10mr3737587oeo.42.1370748912243; Sat, 08 Jun 2013 20:35:12 -0700 (PDT) Received: from [35.8.77.198] ([35.8.77.198]) by mx.google.com with ESMTPSA id dz4sm11038076obb.14.2013.06.08.20.35.08 for (version=TLSv1 cipher=RC4-SHA bits=128/128); Sat, 08 Jun 2013 20:35:11 -0700 (PDT) User-Agent: Microsoft-MacOutlook/14.3.4.130416 Date: Sat, 08 Jun 2013 23:35:04 -0400 Subject: Re: DBD::Pg requires at least protocol version 3.0 From: l duynslager To: Greg Sabino Mullane CC: Message-ID: Thread-Topic: [ADMIN] DBD::Pg requires at least protocol version 3.0 In-Reply-To: <30d598c96588db55746c3556bf57d761@biglumber.com> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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=20 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=3D64 -DHAVE_PQescapeString -DHAVE_PQescapeBytea -DHAVE_PQunescapeBytea -DHAVE_PQfreemem -O2 -g -DPERL_EXTMALLOC_DEF -Dmalloc=3DPerl_malloc -Dfree=3DPerl_mfree -Drealloc=3DPerl_realloc -Dcalloc=3DPerl_calloc -DVERSION=3D\"1.32\" -DXS_VERSION=3D\"1.32\" -fPIC "-I/usr/lib/perl/5.14/CO= RE" Pg.c Pg.xs: In function =8CXS_DBD__Pg__db_quote=B9: Pg.xs:95:8: warning: format =8C%i=B9 expects argument of type =8Cint=B9, but argument 2 has type =8CIV=B9 [-Wformat] Pg.xs: In function =8CXS_DBD__Pg__db_lo_open=B9: Pg.xs:166:59: error: =8Csv_undef=B9 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 =8CXS_DBD__Pg__db_lo_close=B9: Pg.xs:173:52: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:173:62: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_read=B9: Pg.xs:194:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_write=B9: Pg.xs:205:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_lseek=B9: Pg.xs:216:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_creat=B9: Pg.xs:225:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_tell=B9: Pg.xs:234:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_unlink=B9: Pg.xs:242:57: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:242:67: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_import=B9: Pg.xs:251:53: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_export=B9: Pg.xs:260:67: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:260:77: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_putline=B9: Pg.xs:269:32: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:269:42: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_getline=B9: Pg.xs:287:32: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:287:42: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_endcopy=B9: Pg.xs:294:47: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:294:57: error: =8Csv_no=B9 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 =8CXS_DBD__Pg__db_quote=B9: Pg.xs:95:8: warning: format =8C%i=B9 expects argument of type =8Cint=B9, but argument 2 has type =8CIV=B9 [-Wformat] Pg.xs: In function =8CXS_DBD__Pg__db_lo_open=B9: Pg.xs:166:59: error: =8Csv_undef=B9 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 =8CXS_DBD__Pg__db_lo_close=B9: Pg.xs:173:52: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:173:62: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_read=B9: Pg.xs:194:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_write=B9: Pg.xs:205:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_lseek=B9: Pg.xs:216:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_creat=B9: Pg.xs:225:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_tell=B9: Pg.xs:234:59: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_unlink=B9: Pg.xs:242:57: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:242:67: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_import=B9: Pg.xs:251:53: error: =8Csv_undef=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_lo_export=B9: Pg.xs:260:67: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:260:77: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_putline=B9: Pg.xs:269:32: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:269:42: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_getline=B9: Pg.xs:287:32: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:287:42: error: =8Csv_no=B9 undeclared (first use in this function) Pg.xs: In function =8CXS_DBD__Pg__db_endcopy=B9: Pg.xs:294:47: error: =8Csv_yes=B9 undeclared (first use in this function) Pg.xs:294:57: error: =8Csv_no=B9 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 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin