Hi!
> Do you use stored procedures in SQL? Apparently the database tries to
> load the library from it's old location (i. e. where the legacy
> packages stored them).
The output of pg_dumpall includes the following repeated for every
database being dumped:
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler'
LANGUAGE c;
I do not really know why it is there.
Also, the old postgresql.conf contained a "dynamic_library_path" setting
pointing to the old locations, and it was not updated to the new paths
used by the postgresql-7.4 package when postgresql.conf was moved to its
new location.
Gabor
--
---------------------------------------------------------
MTA SZTAKI Computer and Automation Research Institute
Hungarian Academy of Sciences,
Laboratory of Parallel and Distributed Systems
Address : H-1132 Budapest Victor Hugo u. 18-22. Hungary
Phone/Fax : +36 1 329-78-64 (secretary)
W3 : http://www.lpds.sztaki.hu
---------------------------------------------------------
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
