pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere does the xlateSqlType symbol point to?
5+ messages / 2 participants
[nested] [flat]
* Where does the xlateSqlType symbol point to?
@ 2004-07-30 13:33 LISTMAN <LISTMAN@terra.es>
2004-07-30 18:00 ` Re: Where does the xlateSqlType symbol point to? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: LISTMAN @ 2004-07-30 13:33 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; pgsql-admin
Hi all,
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
Searched for various libraries, but couldn't find anything.
Do I need to install more packages? What I am doing wrong?
Thanks.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Where does the xlateSqlType symbol point to?
2004-07-30 13:33 Where does the xlateSqlType symbol point to? LISTMAN <LISTMAN@terra.es>
@ 2004-07-30 18:00 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-07-30 18:00 UTC (permalink / raw)
To: listman@terra.es; +Cc: pgsql-hackers@postgresql.org; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [HACKERS] Where does the xlateSqlType symbol point
@ 2004-08-03 09:48 LISTMAN <LISTMAN@terra.es>
0 siblings, 0 replies; 5+ messages in thread
From: LISTMAN @ 2004-08-03 09:48 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; pgsql-admin
Hi Tom,
Thanks for your answer.
You mean I need to download another version and install it? If there is
anything to prevent a re-install, let me know it please.
The one installed and downloaded is the PostgreSQL 7.3.4 version of the
package. I have the following software installed (listing produced with
rpm -qa):
postgresql-test-7.3.4-2mdk
postgresql-devel-7.3.4-2mdk
postgresql-contrib-7.3.4-2mdk
postgresql-docs-7.3.4-2mdk
postgresql-7.3.4-2mdk
postgresql-tcl-7.3.4-2mdk
postgresql-python-7.3.4-2mdk
postgresql-jdbc-7.3.4-2mdk
postgresql-server-7.3.4-2mdk
I guess it would do, though it's not the latest version. It was
installed on a clean Mandrake 9.2 Linux station under VmWare.
Thanks, LM.
> ----- Mensaje Original -----
> De: Tom Lane <tgl@sss.pgh.pa.us>
> Fecha: Viernes, Julio 30, 2004 8:00 pm
> Asunto: Re: [HACKERS] [ADMIN] Where does the xlateSqlType symbol
> point to?
>
> > 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
> >
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [HACKERS] Where does the xlateSqlType symbol point
@ 2004-08-11 06:55 LISTMAN <LISTMAN@terra.es>
0 siblings, 0 replies; 5+ messages in thread
From: LISTMAN @ 2004-08-11 06:55 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-hackers@postgresql.org; pgsql-admin
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ó:
> 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
>
>
> .
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [HACKERS] Where does the xlateSqlType symbol point
@ 2004-08-12 10:49 LISTMAN <LISTMAN@terra.es>
0 siblings, 0 replies; 5+ messages in thread
From: LISTMAN @ 2004-08-12 10:49 UTC (permalink / raw)
To: ; +Cc: pgsql-hackers@postgresql.org; pgsql-admin; tgl@sss.pgh.pa.us
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
> >
> >
> > .
> >
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-08-12 10:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-30 13:33 Where does the xlateSqlType symbol point to? LISTMAN <LISTMAN@terra.es>
2004-07-30 18:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-03 09:48 Re: [HACKERS] Where does the xlateSqlType symbol point LISTMAN <LISTMAN@terra.es>
2004-08-11 06:55 Re: [HACKERS] Where does the xlateSqlType symbol point LISTMAN <LISTMAN@terra.es>
2004-08-12 10:49 Re: [HACKERS] Where does the xlateSqlType symbol point LISTMAN <LISTMAN@terra.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox