Hi Tom, Just re-installed a new version of Postgres 7.3.4 on a *clean* version of Mandrake 9.2, which seemed to work well. The reference to the xlateSqlType symbol is gone from plpgsql.so.
All postgres packages installed came from the original Mandrake 9.2 CD. After a little search plpgsql.so appeared to have been included in the 'postgresql-pl-7.3.4-2mdk' package. Probably that missed in the other installation where the library came with the 'libpgsql2-7.2.2-1mdk' package. Also, before installing any of the postgres packages in the new 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 version mix. Listman. ----- Mensaje Original ----- De: LISTMAN <[EMAIL PROTECTED]> Fecha: Miercoles, Agosto 11, 2004 8:59 am Asunto: Re: [HACKERS] [ADMIN] Where does the xlateSqlType symbol point to? > Hi Tom, > > After a downgrade to Postgres 7.2.2, I still got the xlateSqlType > symbolnot 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ó: > > LISTMAN <[EMAIL PROTECTED]> writes: > > > >>Having tried various options, I still cannot find the clue where > 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 > 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.> > > regards, tom lane > > > > ---------------------------(end of broadcast)-------------------- > ------- > > TIP 7: don't forget to increase your free space map settings > > > > > > . > > > > > > > > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings