Обсуждение:

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 -- Новая Почта: все по-новому.

<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

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
>
>