Your message dated Sun, 16 Jul 2006 09:32:22 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#360796: fixed in plr 1:0.6.2-3
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: postgresql-7.4-plr
Version: 1:0.6.2-2
Severity: important
Hi,
/usr/share/doc/postgresql-[78].[41]-plr/README.plr suggests
psql mydatabase < plr.sql
So I tried [sorry for the German locale - I tried to unsset environment
variables but psql keeps on spitting German messages, but the maintainer
is known to be German so this should be no big harm]:
$ psql test < /usr/share/postgresql/7.4/plr.sql
SET
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: Funktion plr_call_handler() existiert nicht
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
CREATE TYPE
FEHLER: konnte Bibliothek »/usr/lib/postgresql/7.4/lib/plr.so« nicht laden:
libR.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis
nicht gefunden
FEHLER: Funktion plr_environ() existiert nicht
CREATE TYPE
FEHLER: Sprache »plr« existiert nicht
FEHLER: Sprache »plr« existiert nicht
The very same problem occures for the 8.1 version.
The reason is simple:
$ ldd /usr/lib/postgresql/8.1/lib/plr.so
linux-gate.so.1 => (0xffffe000)
libR.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0xb7ea2000)
/lib/ld-linux.so.2 (0x80000000)
And a quick hack would be
$ sudo ln -s R/lib/libR.so /usr/lib
So it might even be that this bug is nit really related to postgresql-plr
but either to R or psql (which should perhaps extend the LD path).
Kind regards and thanks for maintaining this package
Andreas.
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (501, 'testing'), (50, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages postgresql-7.4-plr depends on:
ii libc6 2.3.5-8 GNU C Library: Shared libraries an
ii postgresql-7.4 1:7.4.9-2 object-relational SQL database, ve
ii r-base-core 2.2.1-6 GNU R core of statistical computin
postgresql-7.4-plr recommends no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: plr
Source-Version: 1:0.6.2-3
We believe that the bug you reported is fixed in the latest version of
plr, which is due to be installed in the Debian FTP archive:
plr_0.6.2-3.diff.gz
to pool/main/p/plr/plr_0.6.2-3.diff.gz
plr_0.6.2-3.dsc
to pool/main/p/plr/plr_0.6.2-3.dsc
postgresql-7.4-plr_0.6.2-3_i386.deb
to pool/main/p/plr/postgresql-7.4-plr_0.6.2-3_i386.deb
postgresql-8.1-plr_0.6.2-3_i386.deb
to pool/main/p/plr/postgresql-8.1-plr_0.6.2-3_i386.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Martin Pitt <[EMAIL PROTECTED]> (supplier of updated plr package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Sun, 16 Jul 2006 18:04:54 +0200
Source: plr
Binary: postgresql-8.1-plr postgresql-7.4-plr
Architecture: source i386
Version: 1:0.6.2-3
Distribution: unstable
Urgency: medium
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description:
postgresql-7.4-plr - Procedural language interface between PostgreSQL 7.4 and R
postgresql-8.1-plr - Procedural language interface between PostgreSQL 8.1 and R
Closes: 360796
Changes:
plr (1:0.6.2-3) unstable; urgency=medium
.
* Urgency medium since this blocks postgresql-7.4 migration to testing and
only has one important bug fix.
* Do not build packages on mips and mipsel any more, since PostgreSQL does
not currently work on these architectures (see bug #357603).
* debian/rules: Add rpath /usr/lib/R/lib to plr.so libraries so that PL/R
can be created without manual hacking. Closes: #360796
Files:
c5ea1e0d77daaa100389ab3215a9e26b 766 libs optional plr_0.6.2-3.dsc
b96934d20c5aecbc1f2e8101a49013e0 3325 libs optional plr_0.6.2-3.diff.gz
9ec61e89ddcd51f36d461ef6c6df2ba3 45604 libs optional
postgresql-7.4-plr_0.6.2-3_i386.deb
4b9107ee186b55ffc626cb8c79ee37dc 46350 libs optional
postgresql-8.1-plr_0.6.2-3_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFEumaVDecnbV4Fd/IRAi6TAJwJYjcLWt4+a5JN+IIaZyYXvY5yiwCgv1Pf
4oPGxjHMJgrUBsNQt4dsJkU=
=WvLm
-----END PGP SIGNATURE-----
--- End Message ---
