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 DD39014B281B; Thu, 12 Aug 2004 07:49:59 -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 56391-02; Thu, 12 Aug 2004 10:49:58 +0000 (GMT) Received: from tfdsmtp2.mail.isp (smtp.terra.es [213.4.129.129]) by svr1.postgresql.org (Postfix) with ESMTP id 80FCD14B2806; Thu, 12 Aug 2004 07:49:46 -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 I2BY2O00.17A; Thu, 12 Aug 2004 12:49:36 +0200 From: LISTMAN Cc: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org, tgl@sss.pgh.pa.us Reply-To: listman@terra.es Message-ID: Date: Thu, 12 Aug 2004 12:49:36 +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/87 X-Sequence-Number: 14482 Hi Tom, Just re-installed a new version of Postgres 7.3.4 on a *clean* version=20 of Mandrake 9.2, which seemed to work well. The reference to the=20 xlateSqlType symbol is gone from plpgsql.so. All postgres packages installed came from the original Mandrake 9.2 CD.=20 After a little search plpgsql.so appeared to have been included in the=20 'postgresql-pl-7.3.4-2mdk' package. Probably that missed in the other installation where the library came=20 with the 'libpgsql2-7.2.2-1mdk' package. Also, before installing any of the postgres packages in the new=20 installation, the libpgsql2-7.2.2-1mdk package was removed (it was there for some reason), to prevent any version mismatch. Thanks again for your hint, I guess I lost the (search)path in the big=20 version mix. Listman. ----- Mensaje Original ----- De: LISTMAN Fecha: Miercoles, Agosto 11, 2004 8:59 am Asunto: Re: [HACKERS] [ADMIN] Where does the xlateSqlType symbol point to? > Hi Tom, >=20 > After a downgrade to Postgres 7.2.2, I still got the xlateSqlType=20 > symbolnot found message. The install includes the packages: >=20 > 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 >=20 > What should I do? >=20 > LM >=20 > Tom Lane escribi=F3: > > LISTMAN writes: > > > >>Having tried various options, I still cannot find the clue where=20 > to llok > >>at concerning the following error message: > > > > > >>Load of file /usr/lib/pgsql/plpgsql.so failed: > >>/usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType > > > > > > I'd say you have a plpgsql.so file that is not the same PG=20 > version as > > your server. I don't have time now to look in the CVS history=20 > and see > > exactly when xlateSqlType appeared or disappeared, but anyway=20 > it's not > > very relevant: fix your installation to have a consistent set of=20 > files.> > > regards, tom lane > > > > ---------------------------(end of broadcast)-------------------- > ------- > > TIP 7: don't forget to increase your free space map settings > > > > > > . > >=20 >=20 >=20 >=20 >=20 >=20 >=20