pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
3+ messages / 3 participants
[nested] [flat]
* (no subject)
@ 2003-03-01 13:50 bishop@nm.ru
0 siblings, 1 reply; 3+ messages in thread
From: bishop@nm.ru @ 2003-03-01 13:50 UTC (permalink / raw)
To: pgsql-sql
Hello.
I have a problem with PL/pgSQL.
When i try to create plpgsql_call_handler() by
CREATE FUNCTION plpgsql_call_handler ()
RETURNS OPAQUE
AS '/opt/pgsql/lib/plpgsql.so'
LANGUAGE 'C';
i receive following message:
ERROR: Load of file /opt/pgsql/lib/plpgsql.so failed: /opt/pgsql/lib/plpgsql.so: undefined symbol: getTypeInputInfo
What shoul i do?
plpgsql.so file exists and the path to it is correct.
Thanks for help.
__________
www.newmail.ru -- Новая Почта: все по-новому.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:
@ 2003-03-02 06:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: bishop@nm.ru
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2003-03-02 06:10 UTC (permalink / raw)
To: bishop@nm.ru; +Cc: pgsql-sql
<bishop@nm.ru> writes:
> i receive following message:
> ERROR: Load of file /opt/pgsql/lib/plpgsql.so failed: /opt/pgsql/lib/plpgsql.so: undefined symbol: getTypeInputInfo
> What shoul i do?
Check versions. I suspect you are trying to load a 7.3 plpgsql.so into
a pre-7.3 backend.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:
@ 2003-03-02 21:58 Zodiac <bishop@nm.ru>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Zodiac @ 2003-03-02 21:58 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Thanx for help!
It works now.
Bishop
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: <bishop@nm.ru>
Cc: <pgsql-sql@postgresql.org>
Sent: Sunday, March 02, 2003 9:10 AM
Subject: Re: [SQL]
> <bishop@nm.ru> writes:
> > i receive following message:
> > ERROR: Load of file /opt/pgsql/lib/plpgsql.so failed:
/opt/pgsql/lib/plpgsql.so: undefined symbol: getTypeInputInfo
> > What shoul i do?
>
> Check versions. I suspect you are trying to load a 7.3 plpgsql.so into
> a pre-7.3 backend.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> __________
> Доступ в Интернет по очень низким тарифам!
> http://www.comrad.ru
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-03-02 21:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-01 13:50 bishop@nm.ru
2003-03-02 06:10 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
2003-03-02 21:58 ` Re: Zodiac <bishop@nm.ru>
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