X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0789514B2804; Wed, 11 Aug 2004 03:55:29 -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 63103-09; Wed, 11 Aug 2004 06:55:23 +0000 (GMT) Received: from tfdsmtp2.mail.isp (smtp.terra.es [213.4.129.129]) by svr1.postgresql.org (Postfix) with ESMTP id D6C4514B2800; Wed, 11 Aug 2004 03:55:08 -0300 (ADT) Received: from terra.es ([10.20.4.99]) by tfdsmtp2.mail.isp (Netscape Messaging Server 4.15 tfdsmtp2 Mar 14 2002 21:29:48) with ESMTP id I29SJW00.NSA; Wed, 11 Aug 2004 08:55:08 +0200 From: LISTMAN To: Tom Lane , pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org Reply-To: listman@terra.es Message-ID: Date: Wed, 11 Aug 2004 08:55:09 +0200 X-Mailer: Netscape Webmail MIME-Version: 1.0 Content-Language: es Subject: Re: [HACKERS] Where does the xlateSqlType symbol point X-Accept-Language: es Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=DNS_FROM_RFCI_DSN X-Spam-Level: * X-Archive-Number: 200408/69 X-Sequence-Number: 14464 Hi Tom, After a downgrade to Postgres 7.2.2, I still got the xlateSqlType symbol not found message. The install includes the packages: libpgsql2-7.2.2-1mdk postgresql-7.2.2-1mdk postgresql-jdbc-7.2.2-1mdk postgresql-server-7.2.2-1mdk libecpg3-7.2.2-1mdk libpgsqlodbc0-7.2.2-1mdk librrdtool0-1.0.38-3mdk librrdtool0-devel-1.0.28-3mdk rrdtool-1.0.38-3mdk libpgtcl2-7.2.2-1mdk What should I do? LM Tom Lane escribi=F3: > LISTMAN writes: >=20 >>Having tried various options, I still cannot find the clue where to llok >>at concerning the following error message: >=20 >=20 >>Load of file /usr/lib/pgsql/plpgsql.so failed: >>/usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType >=20 >=20 > I'd say you have a plpgsql.so file that is not the same PG version as > your server. I don't have time now to look in the CVS history and see > exactly when xlateSqlType appeared or disappeared, but anyway it's not > very relevant: fix your installation to have a consistent set of files. >=20 > regards, tom lane >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >=20 >=20 > . >=20