From skarthi98@hotmail.com Mon Feb 5 21:37:47 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A9CEB9FB249; Mon, 5 Feb 2007 17:37:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 72062-04; Mon, 5 Feb 2007 17:37:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s40.bay0.hotmail.com (bay0-omc3-s40.bay0.hotmail.com [65.54.246.240]) by postgresql.org (Postfix) with ESMTP id AEA769F9F80; Mon, 5 Feb 2007 17:37:42 -0400 (AST) Received: from hotmail.com ([65.55.136.109]) by bay0-omc3-s40.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 5 Feb 2007 13:37:41 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 5 Feb 2007 13:37:41 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Mon, 05 Feb 2007 21:37:40 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: From: "Karthikeyan Sundaram" To: pgsql-sql@postgresql.org Cc: pgsql-php@postgresql.org, pgsql-admin@postgresql.org Subject: Symbol lookup error Date: Mon, 05 Feb 2007 13:37:40 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 05 Feb 2007 21:37:41.0184 (UTC) FILETIME=[DD071400:01C7496D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.962 tagged_above=0 required=5 tests=AWL, BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/64 X-Sequence-Number: 24529 Hi Gurus, I hae installed postgres 8.2 recently and when I open the psql command line prompt and say \d . The psql abort abruptly with an error message given below. What is the cause and how to rectify it? Error Message ========= Welcome to psql 8.2.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit podcast=> \d channel psql: symbol lookup error: psql: undefined symbol: PQescapeStringConn Regards skarthi _________________________________________________________________ Check out all that glitters with the MSN Entertainment Guide to the Academy Awards® http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline2 From tgl@sss.pgh.pa.us Mon Feb 5 21:49:20 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 26D529FA177; Mon, 5 Feb 2007 17:49:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 28143-02; Mon, 5 Feb 2007 17:49:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C8A469FA2A1; Mon, 5 Feb 2007 17:49:13 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l15LnBhA021264; Mon, 5 Feb 2007 16:49:11 -0500 (EST) To: "Karthikeyan Sundaram" cc: pgsql-sql@postgresql.org, pgsql-php@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Symbol lookup error In-reply-to: References: Comments: In-reply-to "Karthikeyan Sundaram" message dated "Mon, 05 Feb 2007 13:37:40 -0800" Date: Mon, 05 Feb 2007 16:49:10 -0500 Message-ID: <21263.1170712150@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/65 X-Sequence-Number: 24530 "Karthikeyan Sundaram" writes: > podcast=> \d channel > psql: symbol lookup error: psql: undefined symbol: PQescapeStringConn It looks like your psql has linked to an obsolete version of libpq.so, though it's not real clear why the thing would have started at all if that were the situation ... regards, tom lane