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 <LISTMAN@terra.es>
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 <LISTMAN@terra.es> 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
> >
> >
> > .
> > 
> 
> 
> 
> 
> 
> 



Thu, 12 Aug 2004 12:49:36 +0200
LISTMAN <LISTMAN@terra.es>
Re: [HACKERS] Where does the xlateSqlType symbol point