Обсуждение: Possible bug in RPM-packaging of PostgreSQL 7.1-1

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : René Pijlman
Your email address    : rpijlman@spamcop.net


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Intel Pentium

  Operating System (example: Linux 2.0.26 ELF)     : Red Hat Linux 7.0

  PostgreSQL version (example: PostgreSQL-7.1):   PostgreSQL-7.1-1

  Compiler used (example:  gcc 2.8.0)        : n/a (installed binary RPMs)


Please enter a FULL description of your problem:
------------------------------------------------
After installation of the 7.1-1 binary RPMs, I did a createlang and got an
error message:

>bash-2.04$ createlang plpgsql leren
>createlang: cannot find the file '/usr/share/pgsql/plpgsql.so'
>
>This file contains the call handler for PL/pgSQL.  By default,
>only PL/pgSQL is built and installed; other languages must be
>explicitly enabled at configure time.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
See above.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
I found the library plpgsql.so in a different location (/usr/lib), so I made
a symbolic link:

(logged in as 'root')
>[root@lab /root]# ln -s /usr/lib/plpgsql.so /usr/share/pgsql

And then the same createlang command worked fine.

So the problem appears to be that plpgsql.so is installed in a different
directory than createlang expects it.

René Pijlman wrote:
> >createlang: cannot find the file '/usr/share/pgsql/plpgsql.so'

> I found the library plpgsql.so in a different location (/usr/lib), so I made
> a symbolic link:

Thanks for the report.  I don't know why the regression tests find it
(as they also use createlang).

I'll fix it for -2.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Lamar Owen <lamar.owen@wgcr.org> writes:
> Thanks for the report.  I don't know why the regression tests find it
> (as they also use createlang).

pg_regress makes a point of passing an explicit -L switch to createlang,
so it's not too surprising that that might mask a path problem ...

            regards, tom lane