Hi,
> > ERROR: could not access file "/usr/lib/postgresql/lib/plpgsql.so": No such
> > file or directory
> > ERROR: function public.plpgsql_call_handler() does not exist
> > ERROR: function plpgsql_call_handler() does not exist
> >
> > Despite the errors the result of the upgrade seems to be OK so far (at
> > least the data seems to be there).
>
> This is really hard to fix, I'm not sure whether it is a good idea
> just to do a dumb search and replace in the dump stream. Also, it does
> not occur with my databases, so this might be a corner case. Does this
> actually hurt in any way? I. e. is the update performed successfully?
> If so, I would prefer the small annoyance of the error message over
> fiddling with the dump output.
It seems to be just an annoyance, but then I do not use PL/PgSQL.
However I'm now reasonably confident that this is the result of this line
in (some) old postgresql postinst:
/sbin/start-stop-daemon --chuid postgres --name enable_lang --startas
/usr/lib/postgresql/bin/enable_lang --start -- plpgsql --all >/dev/null 2>&1 ||
true
In version 7.4.7 this is protected by a debconf variable but in version
7.2.1 (from Woody) enable_lang was called unconditionally.
The machine where I experienced the problem was installed cca. 3.5 years
ago and is tracking unstable nearly daily since then, so it has
survived multiple PostgreSQL database upgrades. On a machine installed
about 3 months ago (base install from Sarge, then dist-upgraded to Sid
before installing any packages), I do not have any references to
plpgsql_call_handler in the database dump.
I have a feeling that this problem will affect people who originally
created their databases under Woody (or before) and upgraded from there,
so I think it should be mentioned in README.Debian at least.
What may be more important that postgresql 7.4.7-3 puts an explicit
dynamic_library_path setting in postgresql.conf that is not updated
during the upgrade, and that may cause problems.
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]
