Re: BUG #5642: pg_upgrade does not handle shared libraries for language handlers - Mailing list pgsql-bugs

David Platt wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5642
> Logged by:          David Platt
> Email address:      davidplatt@davidplatt.com
> PostgreSQL version: 9.0 RC1
> Operating system:   CentOS 5.5
> Description:        pg_upgrade does not handle shared libraries for language
> handlers
> Details:
>
> The following definition is my database:
>
> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
>     LANGUAGE c
>     AS '/opt/postgres/8.4.1/lib/plpgsql', 'plpgsql_call_handler';
>
> The file /opt/postgres/9.rc1/lib/plpgsql.o exists but the pg_upgrade run
> fails on an error loading /opt/postgres/8.4.1/lib/plpgsql.o.

What is the error?  What old version of PG are you migrating from?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +