Re: [HACKERS] Where does the xlateSqlType symbol point
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ó:
Show quoted text
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: xlateSqlTypeI'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.
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?
Show quoted text
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-1mdkWhat 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: xlateSqlTypeI'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
.
Import Notes
Resolved by subject fallback